Make a Macro on a Toolbar

[Sean]

Hi, I created a Macro but I want to have it show up on a
toolbar.
I know that you can create a custom toolbar but how can i
add a macro (which I would need an icon) onto that
toolbar or any toolbar?

Thanks,
Sean

 

[Gord Dibben]

Sean

Tools>Customize>Commands.

Scroll down to "Macros" and select the smi;ey-face button. Drag it up to an
existing toolbar. Right-click on it and "assign macro". Choose your macro
from the dialog box.

Note: you can edit the the smiley-face button.

There are many other ways to do what you want, the above is the basics.

Gord Dibben Excel MVP