Thanks. This was the answer.


Gaston

"George Nicholson" wrote:

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.