XL98: How to Delete, Restore, and Edit Menu Items Manually (179296)



The information in this article applies to:

  • Microsoft Excel 98 Macintosh Edition

This article was previously published under Q179296

SUMMARY

Microsoft Excel 98 Macintosh Edition uses a method to edit, delete, or restore menus and menu items that is different from earlier versions of Microsoft Excel for the Macintosh. This article explains the differences among toolbars, menu bars, and command bars in Microsoft Excel 98 Macintosh Edition. This article also explains in detail how to do the following in Microsoft Excel 98 Macintosh Edition:
  • Delete an entire menu
  • Delete a single menu item
  • Restore an entire menu
  • Restore a single menu item
  • Change settings for a specific menu item
  • Reset a menu item to its original settings

MORE INFORMATION

Behavior in Microsoft Excel Version 5.0

In Excel 5.0, toolbars and menu bars are separate. The differences between toolbars and menu bars are described as follows.

Toolbars:
  • Contain toolbar buttons.
  • Can be docked or undocked (floating).
  • Can be edited by clicking Toolbars on the View menu.
Menu Bars:
  • Contain menus and menu items.
  • Can only be docked (at the top of the screen).
  • Can be edited by clicking Menu Editor on the Tools menu in a Visual Basic for Applications module sheet.

Behavior in Microsoft Excel 98 Macintosh Edition

In Microsoft Excel 98 Macintosh Edition, toolbars and menu bars no longer exist as separate components. "Command bars" have replaced both toolbars and menu bars. Command bars include all of the functionality of toolbars and menu bars in addition to new functionality.

Command Bars:
  • Contain toolbar buttons, menus, and menu items.
  • Can be docked on any edge of the screen or can be undocked (floating).
  • Can be edited by clicking Toolbars on the View menu.
Although toolbars and menu bars no longer exist separately in Microsoft Excel 98 Macintosh Edition, most Visual Basic for Application commands that are designed to work with these items still function, and elements of the user interface use the older terminology. For example, there is a Toolbars menu command on the View menu.

In Microsoft Excel 98 Macintosh Edition, you can edit command bars when the Customize dialog box is displayed. To display this dialog box, click Customize on the Tools menu.

The Customize dialog box is a special dialog box. When it is displayed, you can click menus, menu items, and toolbar buttons on command bars.

IMPORTANT: In the following steps, when you are instructed to click a menu or menu item, do not click inside the Customize dialog box. Instead, click the menu or menu item.

How to Delete an Entire Menu

To delete an entire menu from a command bar, follow these steps:
  1. On the Tools menu, click Customize. Click the Toolbars tab.
  2. In the list of toolbars, click to select either the Worksheet Menu Bar or the Chart Menu Bar check box. The check box to select depends on the menu bar that contains the menu you want to delete.
  3. Press the CONTROL key and click the menu that you want to delete (for example, the Format menu). Do not click the Customize dialog box; instead, click the menu.
  4. On the shortcut menu, click Delete.
The entire menu is deleted. When you are finished making changes, click Close.

How to Delete a Single Menu Item

To delete a single menu item, follow these steps:
  1. On the Tools menu, click Customize. Click the Toolbars tab.
  2. In the list of toolbars, click to select either the Worksheet Menu Bar or the Chart Menu Bar check box. The check box to select depends on the menu bar that contains the menu you want to delete.
  3. Click the menu that contains the item you want to delete. Then, press the CONTROL key and click the specific menu item. Do not click the Customize dialog box; instead click the menu and menu item.
  4. On the shortcut menu, click Delete.
The menu item is deleted. When you are finished making changes, click Close.

How to Restore an Entire Menu

To restore an entire menu that has previously been deleted, follow these steps:
  1. On the Tools menu, click Customize. Click the Toolbars tab.
  2. In the list of toolbars, click to select either the Worksheet Menu Bar or the Chart Menu Bar check box. The check box to select depends on the menu bar that contains the menu you want to restore.
  3. Click the Commands tab.
  4. In the Categories list, click Built-in Menus.
  5. In the Commands list, click the name of the menu that you want to restore (for example, Format). Then drag the menu item to the correct location on the appropriate command bar.
The menu reappears on the command bar. When you are finished making changes, click Close.

How to Restore a Single Menu Item

To restore a single menu item that has previously been deleted, follow these steps:
  1. On the Tools menu, click Customize. Click the Toolbars tab.
  2. In the list of toolbars, click to select either the Worksheet Menu Bar or the Chart Menu Bar check box. The check box to select depends on the menu bar that contains the menu item you want to restore.
  3. Click the Commands tab.
  4. In the Categories list, click the name of the menu that contains the menu item you want to restore.
  5. In the Commands list, click the name of the menu item that you want to restore. Then drag the menu item to the correct location on the appropriate menu.
The menu item reappears on the menu. When you are finished making changes, click Close.

How to Change Settings for a Specific Menu Item

To change a specific menu item (for example, to change a menu item so that it refers to a macro), follow these steps:
  1. On the Tools menu, click Customize. Click the Toolbars tab.
  2. In the list of toolbars, click to select either the Worksheet Menu Bar or the Chart Menu Bar check box. The check box to select depends on the menu bar that contains the menu item you want to change.
  3. Click the Commands tab.
  4. Click the menu that contains the menu item that you want to change. Then, press the CONTROL key and click the menu item.
  5. On the shortcut menu, click Edit Button Image or Change Button Image to change the button image of the menu. Or, to assign the menu item to a macro, click Assign Macro.
When you are finished making changes, click Close.

How to Reset a Menu Item to its Original Settings

To reset a menu item that has been modified, follow these steps:
  1. On the Tools menu, click Customize. Click the Toolbars tab.
  2. In the list of toolbars, click to select either the Worksheet Menu Bar or the Chart Menu Bar check box. The check box to select depends on the menu bar that contains the menu item you want to reset.
  3. Click the Commands tab.
  4. Click the appropriate menu. Then, press the CONTROL key and click the menu item that you want to reset.
  5. On the shortcut menu, click Reset.
The menu item is reset to its original settings. When you are finished making changes, click Close.

Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbinfo kbui KB179296