Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Opening Excel document

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,276
Default Opening Excel document

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default Opening Excel document

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel will not display document upon opening Lee Excel Discussion (Misc queries) 0 February 7th 09 04:11 PM
Excel will not display document upon opening Lee Excel Discussion (Misc queries) 0 February 7th 09 04:10 PM
Opening word document through excel vba srinums Excel Discussion (Misc queries) 0 June 8th 06 12:02 PM
My excel document is opening two versions. Nikki Excel Worksheet Functions 4 January 12th 06 04:21 PM
Opening Word Document with excel [email protected] Excel Discussion (Misc queries) 0 March 21st 05 01:49 AM


All times are GMT +1. The time now is 05:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"