Opening Excel document

[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

 

[Eduardo]

Hi,
before saving press CTRL Home to go to A1 then save it, excel will open
where you save it

 

[Jacob Skaria]

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