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

Hi Randy

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




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Randy" wrote in message oups.com...
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

Thanks, Ron. This is really helpful.

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

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)




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Randy" wrote in message ups.com...
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