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")

--
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?

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?

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?

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?