Opening Excel document

  • Thread starter Thread starter Sallie
  • Start date Start date
S

Sallie

Hello,

I use Excel 2007 and Windows Vista. Can you please tell me how I can manage
to get Excel to always open with the cursor positionned in cell A1 instead of
the last position I used when I saved the document?

Thank you
 
Hi,
before saving press CTRL Home to go to A1 then save it, excel will open
where you save it
 
If you mean to have this for a specific workbook; then from the workbook
Launch VBE using Alt+F11. From the left treeview search for the VBAProject
for this workbook. Click + to expand and double click 'This Workbook'. Paste
the below code to the right code pane and save workbook. Close VBE..Now save
workbook and reopen to see whether it works...

Private Sub Workbook_Open()
Range("A1").Activate
End Sub

If this post helps click Yes
 
Back
Top