Macro runs upon wkbk open, but no Workbook_Open or Auto_Open Macro

G

Guest

I'm drawing a blank here....

I open a workbook containing macros
I enable macros
A macro called IntroMessage runs (displays a msgbox)

If I rename the IntroMessage sub, the workbook, upon opening, displays a
message that the IntroMessage macro cannot be found...then it doesn't open.

When I insert Application.Caller into the IntroMessage sub, the msgbox
displays the file name.

Here's my dilema:
There is no auto_open macro in the workbook
There is no workbook_open macro

What other option am I forgetting?
***********
Regards,
Ron

XL2002, WinXP
 
G

Guest

Range Name: Auto_Open.
Thank you, Tom.

The sad part is......I wrote the darn thing!

They say the eyes are the first thing to go...
The second is....um....I can't remember.

***********
Regards,
Ron

XL2002, WinXP
 

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