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

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

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

Any defined names with the name like Auto_Open and perhaps a hidden macro
sheet.

--
Regards,
Tom Ogilvy


"Ron Coderre" wrote:

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

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

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


"Tom Ogilvy" wrote:

Any defined names with the name like Auto_Open and perhaps a hidden macro
sheet.

--
Regards,
Tom Ogilvy


"Ron Coderre" wrote:

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