Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open event not firing
For some reason, the Workbook_Open event is not firing in one specific
workbook. I created a blank workbook and added the event with a msgbox alert and it worked fine. Any ideas why this event wouldn't be firing? Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open event not firing
It isn't in the thisworkbook module?
-- Regards, Tom Ogilvy "0013" wrote in message ... For some reason, the Workbook_Open event is not firing in one specific workbook. I created a blank workbook and added the event with a msgbox alert and it worked fine. Any ideas why this event wouldn't be firing? Thanks, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open event not firing
Nope, it's in the correct place.
"Tom Ogilvy" wrote: It isn't in the thisworkbook module? -- Regards, Tom Ogilvy "0013" wrote in message ... For some reason, the Workbook_Open event is not firing in one specific workbook. I created a blank workbook and added the event with a msgbox alert and it worked fine. Any ideas why this event wouldn't be firing? Thanks, |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open event not firing
That is the correct place? Tom was suggesting why it didn't work.
-- HTH Bob Phillips "0013" wrote in message ... Nope, it's in the correct place. "Tom Ogilvy" wrote: It isn't in the thisworkbook module? -- Regards, Tom Ogilvy "0013" wrote in message ... For some reason, the Workbook_Open event is not firing in one specific workbook. I created a blank workbook and added the event with a msgbox alert and it worked fine. Any ideas why this event wouldn't be firing? Thanks, |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open event not firing
It's somehow working now. I'm not exactly sure why, but I do have a theory.
I'm guessing that piece of code, which temporarily turns off events, threw an exception and was stoped before it could re-enable events and the document was then saved and closed. If this was the case, I'm guessing it was fixed by successfully re-running that code and saving. "0013" wrote: Right, I was saying that that wasn't the problem b/c it was in the workbook module. "Bob Phillips" wrote: That is the correct place? Tom was suggesting why it didn't work. -- HTH Bob Phillips "0013" wrote in message ... Nope, it's in the correct place. "Tom Ogilvy" wrote: It isn't in the thisworkbook module? -- Regards, Tom Ogilvy "0013" wrote in message ... For some reason, the Workbook_Open event is not firing in one specific workbook. I created a blank workbook and added the event with a msgbox alert and it worked fine. Any ideas why this event wouldn't be firing? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Event sometimes stops firing? | Excel Programming | |||
Code for App level event (not firing) | Excel Programming | |||
Stop Worksheet_SelectionChange event from firing? | Excel Programming | |||
Worksheet change event not firing | Excel Programming | |||
OnTime event not firing in Workbook_Open event procedure | Excel Programming |