Archive of Mr Excel Message Board


Back to Excel VBA archive index
Back to archive home

Worksheet Activate Event doesn't fire

Posted by Dean on February 10, 2002 9:17 PM
I've got a workbook with multiple worksheets A, B, C, etc. Sheet A is active when I save the workbook. In the workbook.open event, I say "a.activate" but it appears that this does not function as the sheet is already active?

If I say:

b.activate
a.activate

then the worksheet_activate event for sheet A fires.

Question is: Am I right about this and is there a more elegant way to trigger the activate event on sheet A than say switching to some other sheet and then back again?


Check out our Excel VBA Resources

Re: Worksheet Activate Event doesn't fire

Posted by DK on February 11, 2002 2:31 AM


Yes, you are right about it. Maybe you could put the code that is currently in your worksheet activate procedure into a sub and then call this when the workbook opens, or when the sheet is activated.

HTH,
D


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.