MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Where does custom menu come from?


Posted by Mike on February 11, 2002 12:54 PM

I have been given a worksheet to investigate, which contains a custom menubar entry. I'm trying to figure out where the code that this menu fires off lives, but my limited Excel knowledge is hindering me.

The new menu is placed to the right of the 'Help' menu. I've looked in Tools->Macros but there is nothing there. I also don't see any code when I browse the project using the VB Editor. I'm pretty sure there is at least one macro in the workbook, because I get a macro warning when I open it in Excel 10.

Where else should I be looking?

Thanks and Best Regards,
Mike


Posted by DRJ on February 11, 2002 1:47 PM

If it is there when you open the workbook then it is probably in the workbook_open module. In the VB editor look the the "This Workbook" module and see if the code is there.

HTH

DRJ

Posted by Mike on February 11, 2002 2:10 PM

Thanks for your response, unfortunately, that's not it. That is what I expected as well, but there is no code there.

Any other places to check?

- Mike


Posted by Richard Winfield on February 11, 2002 9:10 PM

The menu is most likely an add in which would be a .xla file. May or may not be easy to find, depends on how paranoid the author was. May , correction, most likely will be password protected also. Good luck ;)

Rick

Posted by Mike Horgan on February 12, 2002 8:43 AM

Thanks for the pointer Rick. I hope the author wasn't too paranoid, he's gone from this mortal coil. That's why this project was handed off to me.