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. :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top