Shortcut for a macro

J

Jim Simpson

Is there a way to create a shortcut that will run an Excel Macro.

I want to run a macro by simply clicking on one Icon.

Thanks for all help.

Jim
 
G

Gord Dibben

Jim

Where do you want the Icon(button)?

On a Toolbar? On the worksheet?

Toolbar.......Tools>Customize>Commands>Macros. Drag the smiley-face button to
your Toolbar and right-click on it and "Assign Macro"

Worksheet......View>Toolbars>Forms. Click on the Button tool and then draw a
button on the sheet. Right-ckick and "Assign Macro".

I am assuming you have a macro to assign.

Gord Dibben Excel MVP
 
B

bigwheel

You can assign a macro to a button on a custom toolbar. Is that what you
had in mind?
 
Top