Wind

Excel 5.0 and earlier used the "Menu Editor" to build menus. This is no
longer available in versions newer than 5.0. You can't use the "delete"
method or "reset" to get rid of the custom menu items.

You also cannot edit these items to add the ampersand as you wish.

Best thing to do is get rid of them and start over as Bob suggests or edit
them in Excel 5.0

To get rid of the custom menu download Jim Rech's REMOVEMENUS.ZIP file from
Stephen Bullen's site. See instructions and d/l file from:

http://www.bmsltd.ie/MVP/Default.htm


Gord Dibben Excel MVP


On Thu, 27 Jan 2005 09:57:54 -0800, windsurferLA wrote:

Problems are being encountered when moving an XL file with numerous
macros from XL95 to XL97. The XL file macros are linked to a pull down
lists on the menu bar. An example of a screen view can be viewed at the
web site:
http://spreadsheet.home.comcast.net/Xlmenu1.gif

Responses to prior posts have taught me that placing an ampersand before
a letter in a menu name enables one to use a keyboard shortcut to that
menu item. In XL95 I can use the MENU EDITOR to edit the menu items as
shown in:

http://spreadsheet.home.comcast.net/XLmenu4.gif

Ampersands added using the XL95 menu editor then work in XL97, but I
need a way to do it from within XL97. How does one customize / edit this
menu from within XL97 when my custom list “ActionList” does not appear
in the list of menu items. I similarly could not find it listed
elsewhere. See

http://spreadsheet.home.comcast.net/Xlmenu2.gif

Thanks in advance... WindsurferLA