Customize Quick Access Toolbar
 

Subject: Customize Quick Access Toolbar
I am using Excel 2007. I have read several articles on internet how to customize QAT. What I want to do is to add a button which shows as Home icon and then call a Marco from Home Icon to switch me to a specific worksheet. My excel file had several worksheets. While I am entering data in 10th worksheet and if I want to return to worksheet 1, I can click on Home icon.

How do I do that?

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

Customize Quick Access Toolbar
 

On Wednesday, September 19, 2012 10:30:20 PM UTC-4, Ben McClave wrote:
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

Ben:

Thanks so much, your response so useful.

Customize Quick Access Toolbar
 

On Sep 20, 2:14*am, wrote:
Subject: Customize Quick Access Toolbar
I am using Excel 2007. I have read several articles on internet *how to customize QAT. What I want to do is to add a button which shows as Home icon and then call a Marco from Home Icon to switch me to a specific worksheet. My excel file had several worksheets. While I am entering data in 10th worksheet and if I want to return to worksheet 1, I can click on Home icon.

How do I do that?

The standard way to do this is with an add-in, so a .xla file. Have a
look at that.

RBS

Customize Quick Access Toolbar
 

On Sep 20, 10:53*am, "
wrote:
On Sep 20, 2:14*am, wrote:

Subject: Customize Quick Access Toolbar
I am using Excel 2007. I have read several articles on internet *how to customize QAT. What I want to do is to add a button which shows as Home icon and then call a Marco from Home Icon to switch me to a specific worksheet. My excel file had several worksheets. While I am entering data in 10th worksheet and if I want to return to worksheet 1, I can click on Home icon..

How do I do that?

The standard way to do this is with an add-in, so a .xla file. Have a
look at that.

RBS

Sorry, this went to the wrong thread and ignore this.

RBS

Customize Quick Access Toolbar
 

On Wednesday, September 19, 2012 11:00:48 PM UTC-4, (unknown) wrote:
On Wednesday, September 19, 2012 10:30:20 PM UTC-4, Ben McClave wrote:

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



Ben:



Thanks so much, your response so useful.

Happy to help