| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Which Fires First?
Which code would fire first, the workbook_Open event in the
ThisWorkbook module, or Auto_Open in a general code module? Either way, I need to make sure the ThisWorkbook code fires first. Rob |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Which Fires First?
Hi
The Workbook_Open event that fires first - ie before Auto_Open. Best regards Richard On 22 Feb, 14:19, "okrob" wrote: Which code would fire first, the workbook_Open event in the ThisWorkbook module, or Auto_Open in a general code module? Either way, I need to make sure the ThisWorkbook code fires first. Rob |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Which Fires First?
On Feb 22, 8:22 am, "RichardSchollar"
wrote: Hi The Workbook_Open event that fires first - ie before Auto_Open. Best regards Richard On 22 Feb, 14:19, "okrob" wrote: Which code would fire first, the workbook_Open event in the ThisWorkbook module, or Auto_Open in a general code module? Either way, I need to make sure the ThisWorkbook code fires first. Rob- Hide quoted text - - Show quoted text - Thanks... |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Which Fires First?
Why would you not just add a Msgbox in each procedure, and see for yourself?
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "okrob" wrote in message oups.com... On Feb 22, 8:22 am, "RichardSchollar" wrote: Hi The Workbook_Open event that fires first - ie before Auto_Open. Best regards Richard On 22 Feb, 14:19, "okrob" wrote: Which code would fire first, the workbook_Open event in the ThisWorkbook module, or Auto_Open in a general code module? Either way, I need to make sure the ThisWorkbook code fires first. Rob- Hide quoted text - - Show quoted text - Thanks... |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Which Fires First?
Check out
http://www.cpearson.com/excel/events.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "okrob" wrote in message oups.com... Which code would fire first, the workbook_Open event in the ThisWorkbook module, or Auto_Open in a general code module? Either way, I need to make sure the ThisWorkbook code fires first. Rob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| code error after autorecover fires | Excel Programming | |||
| Drop Down Selection fires a module? | Excel Worksheet Functions | |||
| worksheet_change event fires multiple times | Excel Programming | |||
| File|Close w/Save fires Workbook_Open twice | Excel Programming | |||
| CommandBarButton.OnAction prop fires when set? Arg! | Excel Programming | |||
Linear Mode
