| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Activate Not Called When Opening Workbook
I'm using code in the Worksheet_Activate event to load a Menu. This works
fine when manually switching from one worksheet to another. However, when the workbook is first opened, this event is not issued for the active sheet. How can I get this event to run when the workbook is first opened. The active sheet can be any sheet that the user had activated prior to the last worbook close. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SIZE Window, Tile, Worksheet, Workbook, Whatever it's called. | New Users to Excel | |||
| When I open a workbook, another one called Book1 is also opened. W | Excel Discussion (Misc queries) | |||
| why is an Excel file called a workbook? | Excel Discussion (Misc queries) | |||
| Opening a UserForm causes a crash in the Exit procedure (Which is never called) | Excel Programming | |||
| how to make subs/procs can only be called from within the workbook they belong to? | Excel Programming | |||
Threaded Mode
