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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
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 |