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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

action on open 2
execution speed issue when closing files 5
Use VBA to Populate Listbox from Open Spreadsheet 4
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
How to force macros refer to ActiveWorkbook 2
Automatic tab naming 2
Programmaticlly sign and password protect a VBA Project in Excel 2 6
Excel 2003 VBA In directory Open Spreadsheets Extract data 1

Top