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?
|