![]() |
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? |
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? |
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? |
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? |
All times are GMT +1. The time now is 07:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com