Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically open a specific spreadsheet when opening Excel | Setting up and Configuration of Excel | |||
Can you force a spreadsheet to open to a specific cell reference? | Setting up and Configuration of Excel | |||
Open an Excel file to a specific spreadsheet | Excel Programming | |||
How do I automatically open a spreadsheet in a specific worksheet? | Excel Discussion (Misc queries) | |||
How to open another Excel spreadsheet to copy data into current spreadsheet ? | Excel Programming |