View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ben McClave Ben McClave is offline
external usenet poster
 
Posts: 173
Default Customize Quick Access Toolbar

Hello,

First, go to the VBA editor (ALT+F11), insert a new module (InsertModule) and paste this code (where Sheet1 is the "Home" tab):

Sub GoHome()
Sheet1.Activate
'Sheet1.Range("A1").Activate
End Sub

Now, click the Office Button Excel Options. From there, click Customize. In the "Choose Commands" drop down, select "Macros". Click the "GoHome" macro and Add it to the QAT. Once it shows up on the right side of the screen, click the "GoHome" macro and click "Modify" to assign it a picture (there is a Home picture that seems to be the logical choice). Click OK and voila! Now, you can click the Home icon from the QAT and it will take you directly to the Home tab. Alternatively, you could go to a specific cell on the tab by removing the apostrophe from the second line of the macro.

Ben