John Bundy
12/16/2006 12:48:00 PM
I would do this, assuming the menu is still showing up which it sounds like
it is.
1st open vb and select thisworkbook choose Workbook from the left dropdown
and open from the second, this should take you to the code that does the
business.
If that doesn't work then from the excel spreadsheet select the run macro
button and see if it is in that list.
Next, check the add-ins and see if somebody at some point saved it as an add
in.
Finally if all else fails, in vb open each sheet and ctl-f and search for
menu, the code really has to be there somewhere if it is still opening.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.
"windsurferLA" wrote:
> A few years back, I built a large XL97 spreadsheet which includes a
> macro called "CreateMenu" that inserts a custom pull-down item in the
> menu bar. The macro runs and creates the menu items when the file is
> opened, and runs again when the file is closed. I've used this macro on
> several workbooks, and in every other case I can find a macro named
> "CreateMenu()" as a step in the AutoOpen macro and a macro named
> "DeleteMenu()" as a step in the AutoClose macro.
>
> I want to revise the menu items on this large XL97 spreadsheet, but I
> can't find the macro. There is no reference to the a menu macro in the
> AutoClose macro, and there is no AutoOpen macro that I can see. Somehow
> the access to those macros seems to have gotten lost as the file has
> migrated from machine to machine to machine with each upgrade. I also
> can't find any links to any other workbooks. There are no worksheets,
> columns or workbooks to "unhide." I figure that if I can find the
> AutoOpen macro, it would should me the link to the menu creation macro.
>
> any ideas of where it might be hinding?
>