View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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