Open spreadsheet on specific tab
 

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.

Open spreadsheet on specific tab
 

Hi

Paste this event code into the code sheet for ThisWorkbook:

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

Regards,
Per

On 23 Sep., 23:05, Alberta Rose
wrote:
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.

Open spreadsheet on specific tab
 

It works a charm, thanks :)

"Per Jessen" wrote:

Hi

Paste this event code into the code sheet for ThisWorkbook:

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

Regards,
Per

On 23 Sep., 23:05, Alberta Rose
wrote:
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.