#1
|
|||
|
|||
How to force Ctrl-Home on page open?
After I save a document it saves the current state of how the rows are arranged.
Is there a VBA code to force the document to open at the home position, much like when you press Ctrl-Home keys? I could just press Ctrl-Home and save the document but that's always an extra step and I'm lazy. lol |
#2
|
|||
|
|||
Never mind I found this solution that works:
Hit ALT+F11 to open VBA. Select: 'This Workbook' in the VBA Project's 'Miscrosoft Excel Objects' (upper left window) In large right window put the following code: Private Sub Workbook_Open() Sheet1.Range("A1").Select End Sub This will select A1 when Workbook opens. |
Tags |
vba code |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to open Documents folder directly from CTRL+O of Open folder on QAT | scvjudy | Word | 2 | 08-11-2014 10:58 PM |
Force a page break | Emaleth9999 | Mail Merge | 1 | 02-09-2012 02:36 AM |
Open link without pressing Ctrl first & no warning prompt. | jmdraft | Word | 3 | 01-12-2012 10:33 PM |
Force page setup override | jgaffney@hbs.net | Word | 1 | 12-16-2011 06:45 AM |
Ctrl+Home no longer works to get me to beginning of doc. | migdaw01 | Word | 0 | 01-13-2011 12:11 PM |