| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making one sheet always be the default when opening up excel
Hello, I have a program that has many sheets (25). I have one sheet as my
"home page" where I always want users to start. Is there a way to set up excel so anytime someone opens this particular workbook they always see the "Home Page" sheet? Users may save the program under new names, etc. But I am hoping I can set a default to always open the home page. Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making one sheet always be the default when opening up excel
It would take a macro........
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Sheets("YourHomePageSheetName").Select End Sub "Rob" wrote: Hello, I have a program that has many sheets (25). I have one sheet as my "home page" where I always want users to start. Is there a way to set up excel so anytime someone opens this particular workbook they always see the "Home Page" sheet? Users may save the program under new names, etc. But I am hoping I can set a default to always open the home page. Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making one sheet always be the default when opening up excel
Put a macro in to select the "home" sheet, and name it Auto_open.
Rob wrote: Hello, I have a program that has many sheets (25). I have one sheet as my "home page" where I always want users to start. Is there a way to set up excel so anytime someone opens this particular workbook they always see the "Home Page" sheet? Users may save the program under new names, etc. But I am hoping I can set a default to always open the home page. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Default ribbon to open by default when opening xls in browser | Excel Discussion (Misc queries) | |||
| Default Book1 on opening Excel 2002 | Setting up and Configuration of Excel | |||
| Opening to a default sheet every time | Excel Worksheet Functions | |||
| Default Excel opening blank spreadsheet name | Excel Discussion (Misc queries) | |||
| Opening an excel index sheet by default | Excel Discussion (Misc queries) | |||
Linear Mode
