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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 12:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com