Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing menu bar customization from old XL95 files
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing menu bar customization from old XL95 files
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...emoveMenus.zip --- Regards, Norman "JWolf" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing menu bar customization from old XL95 files
Thanks Norman, that's really good.
Norman Jones wrote: 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...emoveMenus.zip --- Regards, Norman "JWolf" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing menu bar customization from old XL95 files
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 On Tue, 01 Jun 2004 15:53:58 -0500, JWolf wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing Menu Bar | Excel Worksheet Functions | |||
Password Boxes from xl95 to xl2000 | Excel Programming | |||
Create CommandBar in xl95 code - possible? | Excel Programming | |||
Adding and Removing Custom Menu Items for one file... | Excel Programming | |||
VBA for XL95, Workbook.open non XL-file | Excel Programming |