Thread
:
Default cell position on file open
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Default cell position on file open
Unless otherwise directed by a macro a file will open to where it was last
saved. So, in the ThisWorkbook module in a before_save or workbook_open
macro put in
application goto sheets("yourdesiredsheetname").range("a1")
--
Don Guillett
SalesAid Software
"Chandramouly" wrote in message
...
Hi,
When I open a new excel file, the file opens with the cursor positioned at
cell A1; for existing files, the default cell positioning is at the last
saved position. Is there a way to change the default position of the
cursor
for all new workbooks. I searched the file options but not able to find a
setting for this.
Regards
Chandra
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett