Assigning a macro to a toolbar button...How?

G

Gord Dibben

Tools>Customize>Commands. Scroll down to "Macros" and select.

You will see two items, "Custom Menu Item" and "Custom Button" smiley face.

Drag that button to the Toolbar.

Right-click on it and see the options to re-name, edit, change icon and other
neat stuff.

Note also the "Assign Macro" option. This is where you assign the macro you
just recorded.

Gord Dibben Excel MVP
 
M

mudraker

Right Click on toolbar
Select Customize
Select command Tab
Select Macros
Drag Icon on to Toolbar
Right Click on new icon
Select Assign Macr
 
Top