Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 -- Sallie |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
before saving press CTRL Home to go to A1 then save it, excel will open where you save it "Sallie" wrote: 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 -- Sallie |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 --------------- Jacob Skaria "Sallie" wrote: 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 -- Sallie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel will not display document upon opening | Excel Discussion (Misc queries) | |||
Excel will not display document upon opening | Excel Discussion (Misc queries) | |||
Opening word document through excel vba | Excel Discussion (Misc queries) | |||
My excel document is opening two versions. | Excel Worksheet Functions | |||
Opening Word Document with excel | Excel Discussion (Misc queries) |