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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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
>