Why does a Multi-sheet/user file open on sheet two every time?

[Frustrated in NJ]

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]

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 here:
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.)