XL2000: Some Commands Are Not Listed in the Customize Dialog Box (200708)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q200708

SYMPTOMS

When you use the Customize dialog box in Microsoft Excel to change the Worksheet menu bar, the following commands may be missing from the Commands list. 
   Command                Menu name     Submenu name
   -------------------------------------------------

   Links                  Edit
   Object                 Edit
   Custom Views           View
   Report Manager         View
   AutoSave               Tools
   Goal Seek              Tools
   Solver                 Tools
   Add-ins                Tools
   Data Analysis          Tools
   Conditional Sum        Tools          Wizard
   Lookup                 Tools          Wizard
   Template Wizard        Data
   MS Access Form         Data
   MS Access Report       Data
   Convert to MS Access   Data

NOTE: There is a Custom Views command in the Commands list. However this command has a drop-down list box. The original Custom Views command does not have a drop-down list box.

CAUSE

This problem occurs when you click Customize on the Tools menu, and then click the Commands tab to add a command that is listed in the table in the "Symptoms" section.

WORKAROUND

You can restore some of the commands by removing, and then adding the reference to an add-in. To do this, follow these steps:

  1. On the Tools menu, click Add-ins.
  2. Click to clear the Add-In name check box. Click OK.
       Add-In name                          Command
   ----------------------------------------------------

   Report Manager                       Report Manager
   Autosave Add-in                      AutoSave
   Solver Add-in                        Solver
   Analysis ToolPak                     Data Analysis
   Conditional Sum Wizard               Conditional Sum
   Lookup Wizard                        Lookup
   Template Wizard with Data Tracking   Template Wizard
   Access Links                         MS Access Form
   Access Links                         MS Access Report
   Access Links                         Convert to MS Access
  3. On the Tools menu, click Add-ins.
  4. Click to select the Add-In name check box. Click OK.

Restoring the Commands That Are Not Created by Add-ins

Installing an add-in does not restore the following commands: 
   Links
   Objects
   Custom Views
   Goal Seek
   Add-ins

To restore these commands, follow these steps.

NOTE: By following these steps, you reset the entire Worksheet toolbar.
  1. On the Tools menu, click Customize, and then click the Toolbars tab.
  2. Click Worksheet Menu Bar. If you clear the Worksheet Menu Bar check box, click the check box again to select it.
  3. Click Reset.

MORE INFORMATION

To view the Customize dialog box, use either of the following methods:
  • On the Tools menu, click Customize.

    -or-
  • Point to Toolbars on the View menu, and then click Customize.

    -or-
  • Move the mouse pointer over the toolbar or menu bar, and then right-click it. Click Customize on the shortcut menu.

REFERENCES

For more information about customizing menu commands, click Microsoft Excel Help on the Help menu, type Customize menus and toolbars in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbprb kbui KB200708
©2003 Microsoft Corporation. All rights reserved.