Excel 2007 : Icon in Quick Access tool bar

[jazbath]

Hi,

I am trying to put an icon in Quick access tool bar and attach a macro to it.
I tried but cannot do it. Any help please? Thanks
Jaz

[Dunc3142]

Record the macro if you haven't already. Click on the customize access toolbar down arrow at the end of the quick access toolbar. Choose more commands. When the customize box comes up, choose macros from the choose commands from pull dorn arrow at the top of the box. Select your macro and click the add button in between the boxes.

This should add your macro to the quick access bar.

[jazbath]

Thanks Dunc
Jaz

[Andy Pope]

You can also use the Modify button on the customise dialog to alter the icon displayed for user macros.