| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to open a workbook on a specific worksheet.
Can anyone show me how to have a multiple page workbook always open to the
same worksheet. (Splash Page) Thanks Kevin |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to open a workbook on a specific worksheet.
Option Explicit
Sub auto_Open() worksheets("splashSheet").select end sub Change the worksheet name to what you want. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm kevincanuk wrote: Can anyone show me how to have a multiple page workbook always open to the same worksheet. (Splash Page) Thanks Kevin -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to open a workbook on a specific worksheet.
Thanks very much Dave ...Works Great!!
"Dave Peterson" wrote: Option Explicit Sub auto_Open() worksheets("splashSheet").select end sub Change the worksheet name to what you want. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm kevincanuk wrote: Can anyone show me how to have a multiple page workbook always open to the same worksheet. (Splash Page) Thanks Kevin -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| HOW DO I PRINT A LIST OF WORKSHEET TITLES FOR A SPECIFIC WORKBOOK | Excel Discussion (Misc queries) | |||
| Open worksheet at specific cell | Excel Discussion (Misc queries) | |||
| cant open for workbook editing | Excel Discussion (Misc queries) | |||
| How to open a workbook with a specific worksheet displayed by defa | New Users to Excel | |||
Hybrid Mode
