Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-11-2016, 03:03 PM
Auto Auto is offline How to force Ctrl-Home on page open? Windows 8 How to force Ctrl-Home on page open? Office 2007
Novice
How to force Ctrl-Home on page open?
 
Join Date: Mar 2016
Posts: 9
Auto is on a distinguished road
Exclamation 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
Reply With Quote
  #2  
Old 03-11-2016, 03:38 PM
Auto Auto is offline How to force Ctrl-Home on page open? Windows 8 How to force Ctrl-Home on page open? Office 2007
Novice
How to force Ctrl-Home on page open?
 
Join Date: Mar 2016
Posts: 9
Auto is on a distinguished road
Default

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.
Reply With Quote
Reply

Tags
vba code



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to force Ctrl-Home on page open? 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
How to force Ctrl-Home on page open? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:36 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft