Removing menu bar customization from old XL95 files

[JWolf]

I added custom menu items in a file written with XL95. The files have
been updated to XL2000 and they still use the custom menu items from the
original XL95 workbooks. Does anyone know where to delete these custom
menu items, as I cannot find them in my code nor can I find a way to
delete them permanently. Can I safely delete my excel.xlb file?

 

[Norman Jones]

Hi,

XL 95 menus are not stored in the xlb file.
To remove these menus, download a Jim Rech's Removemenus.xla from stephen
Bullens site:

http://www.bmsltd.ie/DLCount/DLCount.asp?file=RemoveMenus.zip

 

[JWolf]

Thanks Norman, that's really good.

Hi,

XL 95 menus are not stored in the xlb file.
To remove these menus, download a Jim Rech's Removemenus.xla from stephen
Bullens site:

http://www.bmsltd.ie/DLCount/DLCount.asp?file=RemoveMenus.zip

 

[Gord Dibben]

JWolf

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(as you have learned).

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