The information in this article applies to:
- Microsoft Excel 97 for Windows
SYMPTOMS
If you customize a menu in Microsoft Excel 97, the menu changes may not be
saved when you save, close and reopen the workbook.
CAUSE
Your customizations to a menu in Microsoft Excel 97 may not be saved with
your workbook if the following conditions are true:
- The workbook was originally created in either Microsoft Excel version
5.0 or 7.0.
-and-
- You created custom menus in this workbook using the Menu Editor in
either Microsoft Excel version 5.0 or 7.0.
-and-
- You have saved your workbook in the Microsoft Excel 97 format.
RESOLUTION
You cannot save modifications (made in Microsoft Excel 97) to custom menus
you create in earlier versions of Microsoft Excel. If you want to remove
custom menus created in earlier versions of Microsoft Excel, copy the
contents of your workbook to a new Microsoft Excel 97 workbook. Use the
Move or Copy Sheet command from the Edit menu to copy the sheets. The
Custom menus are not copied to the new workbook.
Steps to Copy All Sheets to a New Workbook
1. Close all open workbooks and open the workbook that contains the
undesired custom menu.
Right-click a sheet tab, and then click Select All Sheets.
From the Edit menu click Move or Copy Sheet. From the To book:
drop-down list, click (new book). Select the Create a copy option
and click OK. This will copy all sheets to a new workbook and
activate the new workbook.
If there are not any macros in the original workbook continue with
step 10, otherwise activate the original workbook that contains the
macros. Click the workbook name from the Window menu to accomplish
this.
On the Tools menu, point to Macro, and then click Visual Basic Editor.
On the View menu, click Project Explorer.
In the Project Explorer, drag each module from the Modules folder of
the original workbook to the new workbook created in step 3.
On the File menu, click Close and Return to Microsoft Excel.
Click Close from the File menu to close the original workbook.
Save the new workbook. This workbook will now allow you to modify the
menu.
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
In Microsoft Excel 97, you do not use the Menu Editor the same as you did
in earlier versions of Microsoft Excel. To work with menus in Microsoft
Excel 97, read each of the sections listed below.
Customize Existing Menus
This example will customize the Window menu on the Worksheet menu bar.
- On the Tools menu, click Customize.
You will now be able to customize the menus in Microsoft Excel 97.
- When the Customize dialog box appears, click Window on the Worksheet
Menu Bar.
- Right click Split and then click Delete on the shortcut menu.
- Click Close on the Customize dialog box.
If you click Window, the Split menu item is not on the menu.
- On the Tools menu click Customize.
- When the Customize dialog box appears, right click Window on the
Worksheet Menu Bar.
- Click Reset on the shortcut menu that appears.
- Click Close on the Customize dialog box.
If you click Window, the Split menu item is back on the menu.
Creating a New Custom Menu
- On the Tools menu click Customize.
- In the Customize dialog box click the Commands tab.
- In the Categories list box, scroll down to the bottom of the list and
click New Menu.
On the right side of the Commands tab, New Menu is listed under Commands:.
- Drag New Menu to the Worksheet Menu Bar and place it to the right
of the Help menu.
Note: When you move "New Menu" up to the Worksheet Menu Bar, an insertion
line becomes visible to assist you in locating your new menu.
- In the Categories list box, click Macros.
On the right side of the Commands tab, you now see Custom Menu Item and
Custom Button under Commands:.
- Drag Custom Button and place it (do not drop it yet) on top of New
Menu that now appears on the Worksheet Menu bar.
- A small empty menu appears below New Menu. Drop Custom Button on
this small empty menu.
Note" The insertion marker should be in the empty menu that appears below
New Menu in order for Custom Button to become a menu item on New Menu.
- Right click Custom Button, which is now a menu item on New Menu.
A shortcut menu appears with a list of all the changes you can make to this
menu item. The following is a partial list of the things you can do:
- change the name to something other than Custom Button
- change the button image on this menu item
- assign a macro to this menu item
- delete the menu item
- Click Close on the Customize dialog box to finish customizing your
menus.
REFERENCES
For more information about Customizing Menus, click the Index tab in
Microsoft Excel 97 Help, type the following text
menus, setting defaults for commands
and then double-click the selected text to go to the "Restore original
settings for a built-in toolbar button or menu command" topic.
|