Microsoft KB Archive/179502

= XL98: Some Commands Are Not Listed in the Customize Dialog Box =

Article ID: 179502

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



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.
 * 1) 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.

