| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to force workbook to always open on the index sheet tab
Hi, I have a workbook, comprising several sheets, one of which is the Index
tab, and the rest a sheet/ tab for each user. users often save the workbook while it is open on their tab, but i would like to build in some VBA code somewhere, so that the workbook will always open in the Index tab/worksheet, regardless of where it was last saved. Could someone please assist me (remember I am a relative novice !) ? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to force workbook to always open on the index sheet tab
Press Alt+F11 to enter the VB Editor.
Double-click on 'ThisWorkbook' and the paste the following code. Private Sub Workbook_Open() Sheets("Index").Activate End Sub HTH, Paul "p1518" wrote in message ... Hi, I have a workbook, comprising several sheets, one of which is the Index tab, and the rest a sheet/ tab for each user. users often save the workbook while it is open on their tab, but i would like to build in some VBA code somewhere, so that the workbook will always open in the Index tab/worksheet, regardless of where it was last saved. Could someone please assist me (remember I am a relative novice !) ? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to force workbook to always open on the index sheet tab
Thank you Paul,
"PCLIVE" wrote: Press Alt+F11 to enter the VB Editor. Double-click on 'ThisWorkbook' and the paste the following code. Private Sub Workbook_Open() Sheets("Index").Activate End Sub HTH, Paul "p1518" wrote in message ... Hi, I have a workbook, comprising several sheets, one of which is the Index tab, and the rest a sheet/ tab for each user. users often save the workbook while it is open on their tab, but i would like to build in some VBA code somewhere, so that the workbook will always open in the Index tab/worksheet, regardless of where it was last saved. Could someone please assist me (remember I am a relative novice !) ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| worksheet to worksheet . . . | Excel Worksheet Functions | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| macro | Excel Discussion (Misc queries) | |||
| CREATE NEW WORKBOOK AND SHEETS BASED ON COLUMN DATA | Excel Worksheet Functions | |||
| Open workbook on same sheet? | Excel Discussion (Misc queries) | |||
Linear Mode
