Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook Open Event
Is there an event that fires before the Workbook Open
event? I need to test for a condition as a file opens but before the workbook open event occurs. This is to late. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook Open Event
The only event that might fire before that would be Auto_Open, but I can't
say if that does or not as I haven't tested it. You could instantiate Application.Level events and see if the Workbook_Open event at the application level might fire first. Again, something you can try, but I haven't tested. Chip Pearson has done some research on this and has a workbook you can download that calls all events. You can start at his entry page http://www.cpearson.com/excel.htm then go to his topics or pages index and find the page. -- Regards, Tom Ogilvy "Steve" wrote in message ... Is there an event that fires before the Workbook Open event? I need to test for a condition as a file opens but before the workbook open event occurs. This is to late. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook open event | Excel Worksheet Functions | |||
Event: open workbook | Excel Discussion (Misc queries) | |||
Workbook Open Event | Excel Programming | |||
Workbook Open event | Excel Programming | |||
Workbook Open Event | Excel Programming |