Open spreadsheet on specific tab

  • Thread starter Thread starter Alberta Rose
  • Start date Start date
A

Alberta Rose

I have a file with multiple worksheets. I want one specific worksheet called
Main to be opened when the file is opened. Right now the file opens which
ever worksheet was viewed last before it was closed. Is there some vba
coding that I could do this with, I've searched, but no luck.

Thanks.
 
Hi

Paste this event code into the code sheet for ThisWorkbook:

Private Sub Workbook_Open()
Worksheets("Main").Activate
End Sub

Regards,
Per
 
It works a charm, thanks :)

Per Jessen said:
Hi

Paste this event code into the code sheet for ThisWorkbook:

Private Sub Workbook_Open()
Worksheets("Main").Activate
End Sub

Regards,
Per
Click to expand...
 
Back
Top