ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Removing menu bar customization from old XL95 files (https://www.excelbanter.com/excel-programming/300099-removing-menu-bar-customization-old-xl95-files.html)

JWolf

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?

Norman Jones

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?




JWolf

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?





Gord Dibben

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