Archive of Mr Excel Message Board
Back to Excel VBA archive index
Back to archive home
need to activate specific sheet upon opening filePosted 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, thanksPosted by Kevin on September 27, 2001 1:12 PM
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.