Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Opening to a default sheet every time
I've created a spreadsheet and want to have it open to the same sheet every
time the Excel file is opened (like a table of contents), and not just the last sheet that was open. I've searched and can't find anything. Any suggestions? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Opening to a default sheet every time
Option Explicit
Sub Auto_Open() application.goto thisworkbook.worksheets("sheet9999").range("A1"), _ Scroll:=true end sub Is one way. Put it in a General module. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Doug wrote: I've created a spreadsheet and want to have it open to the same sheet every time the Excel file is opened (like a table of contents), and not just the last sheet that was open. I've searched and can't find anything. Any suggestions? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data from two sheets make up real time list in the new sheet?? | Excel Worksheet Functions | |||
time sheet determination of what day and time rate | Excel Worksheet Functions | |||
Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
Time Sheet frustrations | Excel Worksheet Functions | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions |