change default file open position for large shared spreadhseet

  • Thread starter Thread starter Frustrated in NJ
  • Start date Start date
F

Frustrated in NJ

We have a large multi-sheet shared file that always opens to the second sheet
with the entire sheet highlighted. Have to constantly switch back to the
first sheet. How do I stop Excel from defaulting to a specific sheet? Or
better yet, how do I set which sheet opens first and where it starts?
 
Excel remembers the selection (and sheet) where it was last saved.

So you could select the sheet/range that you want before you save the workbook.

Or you could have a macro run when excel opens the file and do it for you:

This would go in a General module:

Option Explicit
Sub Auto_Open()
application.goto thisworkbook.worksheets("SheetnameHere").range("A1"), _
scroll:=true
End Sub

(Change the sheet name to match--and the address, too.)

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
 
Back
Top