Workbook Open Event

[Steve]

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.

 

[Tom Ogilvy]

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.