| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
![Per Jessen[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
