Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does a Multi-sheet/user file open on sheet two every time?
We have a multi-sheet file that is updated by several folks. Every time I
open the file it starts on sheet two. I have tried to figure out why this is.. Want to change the default starting position to sheet one at the top but have not been successful in finding that in the help files. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does a Multi-sheet/user file open on sheet two every time?
Excel will open to the same location as the last save--unless you do something
special. One of the special things you can do is have a macro that controls where you want to go. Option Explicit Sub Auto_Open() application.goto thisworkbook.worksheets("SheetNameHere").range("a1 "), _ scroll:=true End sub If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) Frustrated in NJ wrote: We have a multi-sheet file that is updated by several folks. Every time I open the file it starts on sheet two. I have tried to figure out why this is.. Want to change the default starting position to sheet one at the top but have not been successful in finding that in the help files. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open WB on spesific sheet each time (Excel 2003) | Excel Discussion (Misc queries) | |||
In-sheet link to open file not working | Excel Discussion (Misc queries) | |||
hide sheet on file open | Excel Discussion (Misc queries) | |||
how can I open an excel file everytime on certain sheet? | Excel Discussion (Misc queries) | |||
Time to open spread sheet | Excel Discussion (Misc queries) |