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,

Kevin


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
Worksheets("Sheet1").Activate

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.