View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default 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