How to make worksheet always open in same place?

  • Thread starter Thread starter jiwolf
  • Start date Start date
J

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?
 
look in the ThisWorkbook module for either before save or workbook_open

sheets("yoursheetname").select
or
application.goto sheets("yoursheetname").range("a1")
 
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
 
Back
Top