Right-click on the Excel logo left of "File" or at left end of Title bar if not
maximized.

Select "View Code" and paste this into that module.

Private Sub Workbook_Open()
ThisWorkbook.Sheets("Sheet1").Activate
End Sub

If you want to go to a particular cell and have that cell be top left.
Pick a cell on Sheet1 and InsertNameDefine.
Name it Start then use this sub instead

Private Sub Workbook_Open()
Application.Goto Reference:="Start", Scroll:=True
End Sub


Gord Dibben MS Excel MVP

On Tue, 23 Jan 2007 12:52:00 -0800, traveye
wrote:

OK, I have an excel file that many employees use and save thier information
in. If an employees enters info into sheet 4 and then saves it, when the
next employee opens the same file it will open directly to sheet 4. This
file has a "cover page" which is sheet 1. I always want excel to open up to
sheet 1 no matter what sheet it was previously saved in. Is this possible?