If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I set a worksheet to be the default at startup?
I have a workbook that has more than 50 worksheets. I would like the default
to open to the first worksheet when the file is opened, not the last one accessed when last saved. Is it possible to do easily? thanks, dan |
#2
|
|||
|
|||
How do I set a worksheet to be the default at startup?
Put this in a general module:
Option Explict sub auto_Open() application.goto worksheets(1).range("a1"),scroll:=true 'or application.goto worksheets("MyFavoriteSheet").range("a1"),scroll:= true End sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Dan Dobill wrote: I have a workbook that has more than 50 worksheets. I would like the default to open to the first worksheet when the file is opened, not the last one accessed when last saved. Is it possible to do easily? thanks, dan -- Dave Peterson |
#3
|
|||
|
|||
How do I set a worksheet to be the default at startup?
Thanks, Dave! works beautifully...after I changed the spelling of Explicit...
dan "Dave Peterson" wrote: Put this in a general module: Option Explict sub auto_Open() application.goto worksheets(1).range("a1"),scroll:=true 'or application.goto worksheets("MyFavoriteSheet").range("a1"),scroll:= true End sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Dan Dobill wrote: I have a workbook that has more than 50 worksheets. I would like the default to open to the first worksheet when the file is opened, not the last one accessed when last saved. Is it possible to do easily? thanks, dan -- Dave Peterson |
#4
|
|||
|
|||
How do I set a worksheet to be the default at startup?
Oopsie.
Glad it worked for you (after the fix!). Dan Dobill wrote: Thanks, Dave! works beautifully...after I changed the spelling of Explicit... dan "Dave Peterson" wrote: Put this in a general module: Option Explict sub auto_Open() application.goto worksheets(1).range("a1"),scroll:=true 'or application.goto worksheets("MyFavoriteSheet").range("a1"),scroll:= true End sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Dan Dobill wrote: I have a workbook that has more than 50 worksheets. I would like the default to open to the first worksheet when the file is opened, not the last one accessed when last saved. Is it possible to do easily? thanks, dan -- Dave Peterson -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
One worksheet to calulate different items simultaneously | John | Worksheet Functions | 4 | November 28th, 2005 07:07 PM |
How do I change the default startup font on Word? | Ryancomputer2 | New Users | 2 | November 19th, 2005 02:02 AM |
GUID default value | Vladimir | Database Design | 5 | November 11th, 2005 01:08 PM |
Reference Data in Moved Worksheet | tommcbrny | Setting up and Configuration | 1 | December 1st, 2004 06:49 PM |
On opening a spreadsheet. | Pinda | Worksheet Functions | 7 | September 30th, 2003 09:36 PM |