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. |
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. |
All times are GMT +1. The time now is 02:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com