How to make worksheet always open in same place?

[jiwolf]

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?

 

[Don Guillett]

look in the ThisWorkbook module for either before save or workbook_open

sheets("yoursheetname").select
or
application.goto sheets("yoursheetname").range("a1")

 

[Gord Dibben]

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

 

[jiwolf]

sorry Don, but i dont quite understand. can you break it down simpler for
me?

 

[Don Guillett]

As Gord said, put in the ThisWorkbook module and it will then be automatic.