Worksheet_Activate Not Called When Opening Workbook
One way: Change the Worksheet_Activate event from Private to Public, then
add the following to ThisWorkbook module:
Private Workbook_Open()
Worksheets("MySheet").Worksheet_Activate
End Sub
HTH,
--
George Nicholson
Remove 'Junk' from return address.
"Gaston" wrote in message
...
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.
|