Thread
:
How to make worksheet always open in same place?
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
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?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett