Opening a workbook to a certain sheet

[alpine7411]

I have a workbook with 7 sheets. I need it to open to a certain sheet
everytime it opens up. Regardless of which sheet it was on when it was
last saved and closed. Is there a way to do this with a macro? And if
so how?

 

[JW]

In the ThisWorkbook module, place something like this:
Sub Workbook_Open()
Sheets("Select_Me").Activate
End Sub

 

[alpine7411]

In the ThisWorkbook module, place something like this:
Sub Workbook_Open()
Sheets("Select_Me").Activate
End Sub





- Show quoted text -

It works...Thanks