Only through the use of VBA.

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

'where startpoint is a named cell, say "gohere" which refers to Sheet1!H56

Sheet1!H56 will be top left cell in view.

To enter this code, right-click on the Excel logo at left end of Worksheet Menu
Bar.

Select "View Code".

Copy and paste into that module which is Thisworkbook module.

Save/close and re-open to test.


Gord Dibben MS Excel MVP

On Sun, 9 Jul 2006 19:29:40 +0100, "jiwolf" wrote:

I have a worksheet shared by several users. is it possible to make the sheet
always open in the same place, regardless of where it was when the last user
saved it?