Archive of Mr Excel Message Board

Back to Excel VBA archive index
Back to archive home

need to activate specific sheet upon opening file

Posted by Kevin on September 27, 2001 1:01 PM
I need to have a specific sheet in my excel workbook be the active sheet upon opening the workbook, regardless of which sheet was active the last time the workbook was saved. The sheet needs to be activated immediately upon opening, even before any macros run (this file includes an AUTO_OPEN macro). What is the VB code to do this and where do I need to insert it? Thanks in advance,


Check out our Excel VBA Resources

Never mind - I see what I need to do, thanks

Posted by Kevin on September 27, 2001 1:12 PM

This archive is from the original message board at
All contents © 1998-2004
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.