How to make worksheet always open in same place?
 

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?

How to make worksheet always open in same place?
 

look in the ThisWorkbook module for either before save or workbook_open

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

--
Don Guillett
SalesAid Software

"jiwolf" wrote in message
...
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?

How to make worksheet always open in same place?
 

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?

How to make worksheet always open in same place?
 

sorry Don, but i dont quite understand. can you break it down simpler for
me?
"Don Guillett" wrote in message
...
look in the ThisWorkbook module for either before save or workbook_open

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

--
Don Guillett
SalesAid Software

"jiwolf" wrote in message
...
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?

How to make worksheet always open in same place?
 

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

--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
look in the ThisWorkbook module for either before save or workbook_open

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

--
Don Guillett
SalesAid Software

"jiwolf" wrote in message
...
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?