Opening a workbook to a certain sheet
 

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?

Opening a workbook to a certain sheet
 

In the ThisWorkbook module, place something like this:
Sub Workbook_Open()
Sheets("Select_Me").Activate
End Sub
wrote:
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?

Opening a workbook to a certain sheet
 

On Sep 10, 2:49 pm, JW wrote:
In the ThisWorkbook module, place something like this:
Sub Workbook_Open()
Sheets("Select_Me").Activate
End Sub



wrote:
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?- Hide quoted text -

- Show quoted text -

It works...Thanks