Opening on a specific worksheet

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Hi

I have a workbook with dozens of individually named sheets. Can I get Excel
2007 to open the workbook on the same sheet regardless of which sheet I was
working on when I closed/saved the workbook?
 
Tim said:
Hi

I have a workbook with dozens of individually named sheets. Can I get Excel
2007 to open the workbook on the same sheet regardless of which sheet I was
working on when I closed/saved the workbook?
Click to expand...
 
Don't know whats happening with my posts !

Open the VBA code page for ThisWorkbook and enter the following into the
Workbook Open function

Me.Sheets("YourSheetNameToOpen").Select
 
Back
Top