Shortcut for a macro

  • Thread starter Thread starter Jim Simpson
  • Start date Start date
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
 
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
 
You can assign a macro to a button on a custom toolbar. Is that what you
had in mind?
 
Back
Top