LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 50
Default auto-open macro lost within workbook

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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to code VBA: Auto open workbook and run macro March Excel Discussion (Misc queries) 4 November 8th 07 08:25 PM
How: open a workbook with auto macro disabled using code? mike_cutting-edge Excel Programming 1 February 13th 05 06:29 PM
auto run macro on workbook open Mcasteel[_45_] Excel Programming 0 November 15th 04 03:04 PM
auto run macro on workbook open Mcasteel[_43_] Excel Programming 2 November 15th 04 02:57 PM
auto run macro at workbook open Juan Guemes Excel Programming 2 August 28th 04 10:55 PM


All times are GMT +1. The time now is 07:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"