MrExcel Consulting
Your One Stop for Excel Tips & Solutions

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

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

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

Worksheets("Sheet1").Activate