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
|