XL98: Some Commands Are Not Listed in the Customize Dialog Box (179502)


The information in this article applies to:

  • Microsoft Excel 98 Macintosh Edition
This article was previously published under Q179502

SYMPTOMS

When you use the Customize dialog box in Microsoft Excel 98 Macintosh Edition to change the Worksheet menu bar, the following commands may be missing from the Commands list. 
   Command              Menu name     Submenu name
   -----------------------------------------------
   Save as HTML         File
   Custom Views         View
   Report Manager       View
   Goal Seek            Tools
   Solver               Tools
   Conditional Sum      Tools         Wizard
   File Conversion      Tools         Wizard
   Lookup               Tools         Wizard
   Template Wizard      Data
NOTE: There is a Custom Views command in the Commands list. However this command does not appear on the View menu after the Customize dialog box is closed.

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

To restore these commands, use either of the following methods.

NOTE: By following either Method 2 or Method 3, you reset the entire Worksheet menu bar.

Method 1: Reset Individual Menu in Excel

To use this method, follow these steps:
  1. On the Tools menu, click Customize, and then click the Toolbars tab.
  2. Click Worksheet Menu Bar.
  3. Hold the CONTROL key down and click the menu you want to reset.
  4. Click Reset.
  5. Click Close.

Method 2: Reset Worksheet Menu Bar in Excel

To use this method, follow these steps:
  1. On the Tools menu, click Customize, and then click the Toolbars tab.
  2. Click Worksheet Menu Bar.
  3. Click Reset.
  4. Click OK.

    This step resets the entire Worksheet Menu Bar.
  5. Click Close.

Method 3: Delete Settings File

To use this method, follow these steps:

  1. Quit Excel.
  2. Locate the Macintosh HD:System Folder:Preferences folder.
  3. Drag Excel Settings (8) to the Trash.
  4. Start Excel.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

You view the Customize dialog box by using either of the follow 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 hold the CONTROL key down and click. Click Customize on the shortcut menu.

REFERENCES

For more information about adding menu commands, click the Index button in MS Excel Help, type the following text

menus, adding

and then double-click the selected text to go to the "Add a command to a menu" topic.
Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbbug kbui KB179502
©2002 Microsoft Corporation. All rights reserved.