Open spreadsheet on specific tab

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.
 
P

Per Jessen

Hi

Paste this event code into the code sheet for ThisWorkbook:

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

Regards,
Per
 
A

Alberta Rose

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...
 
Top