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
|