Control what Tab opens first when opening a workbook

[MikeM]

I have a Workbook file with many worktabs in it. Such as : Main Page, Cover,
Scorecard.... Whenever I open the file, it always opens to the "Cover"
page. I want it to open to the "Main Page" . How can I contro; this?

 

[Don Guillett]

Before saving goto that sheet>save>close. Put a before_close event macro in
the ThisWorkbook module

 

[Chip Pearson]

Excel opens the file to the location that was active when the file was
closed (assuming you save changes). You can set the startup range in
the Workbook_Open procedure. In VBA, open up the ThisWorkbook module
and enter the following code:

Private Sub Workbook_Open()
ThisWorkbook.Worksheets("Main Page").Select
End Sub

OR you can use

Private Sub Workbook_Open()
Application.Goto _
ThisWorkbook.Worksheets("Main Page").Range("A1"), True
End Sub

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]