Removing excel 5 customized menus?

M

mrl

I have an excel file created under 5.0 that adds a customized menu to
the worksheet menu bar, when it opens up. I can't figure out how to
delete this under later versions of excel. I don't have 5.0 any more.
Any help? Thanks.
 
W

Walt

Hi mrl,

If you can open the code in the VBA editor and the menu is not being
defined there, it was done in the 4.0 macro code (You could still do
this readily in Excel 5.0). If so, look for code something like the
following in the 4.0 macro sheet:

=ADD.MENU(1,Menu_ref,position)

-- the 1 is the ID number for the built-in worksheet menubar
-- where Menu_ref is an array or reference to an area on the macro
sheet that describes the new menu.
-- position is optional and, if omitted will have the menu added to the
far right of the menu bar.

Best Regards,
Walt Weber
 
M

mrl

Thanks. I actually found someone who had a program that removed them
(removemenus.zip). It could only run on the pc, but amazingly it
actually worked. Otherwise, I was about to go dig for excel 5.0 floppy
disks. :)
 
Top