Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA macro runs fine, but freezes if I try to do ANYTHING else whileit runs | Setting up and Configuration of Excel | |||
Auto_Open Workbook_Open | Excel Programming | |||
Auto_Open vs Open and call macro --priority question | Excel Programming | |||
macro only runs on fresh open of excel? | Excel Programming |