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

Last reviewed: February 2, 1998
Article ID: Q179502
The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition

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.


Additional query words: XL98
Keywords : xlui kbui
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbbug
Solution Type : kbpending


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.