Add Custom Button to Quick Access Toolbar

[Randy]

Can anyone tell me how to add a customized button to the Quick Access
Toolbar in Excel 2007 that will launch a macro? I'm not talking about
adding additional Microsoft-defined commands, but one of my own.

Thanks,
Randy

 

[Ron de Bruin]

Hi Randy

You can see how I do it here
http://www.rondebruin.nl/qat2.htm

 

[Randy]

Thanks, Ron. This is really helpful.

Randy

 

[Randy]

Ron,
I'm trying to modify this to fit exactly what I am doing. Let's start
at the beginning. Can you tell me how to simply add a button to the
QAT that will launch a macro (even if the macro is nothing more than
than the basic "Hello World" message box).

Thanks again.
Randy

 

[Ron de Bruin]

Hi Randy

Open a new workbook and save it

Copy this macro in a normal module
http://www.rondebruin.nl/code.htm

Sub test()
MsgBox "Hello Randy"
End Sub

Right click on the QAT and choose Customize Quick Access Toolbar
In the "Choose commands from" dropdown choose Macros and in the Customize Quick Access Toolbar dropdown choose
"YourworkbookName.xlsm"

Select the "test" macro and press Add and then OK.
You can use Modify to change the icon if you want. Then press OK and save the file.

Note : You only have to do this one time because the button is saved with the workbook.
If you send the file to other users they can use your button on the QAT.

See the screenshots on my ribbon page (number 3)