Worksheet view in active window will be whereever it was when you last saved
the workbook.

You could add VBA Event code to show a particular view when that sheet is
activated or when the workbook is opened.

Example of sheet activation event code.

Private Sub Worksheet_Activate()
Application.Goto Range("A1"), Scroll:=True
End Sub

Right-click on the sheet tab and "View Code".

Copy/paste the code into that module.

Alt + q to return to Excel window.


Gord Dibben MS Excel MVP

On Sat, 30 May 2009 09:26:01 -0700, Rebel
wrote:

I want excel to open at the top of my spreadsheet instead of the bottom