Macros I want dont appear in the customise box to drag to a toolbar

  • Thread starter Thread starter Johnnyboy5
  • Start date Start date
J

Johnnyboy5

Hi

I have a macro that works using a key board short cut, but when I try
to assign it to a toolbar function when I select "macros" in the list
of commands the macro I want isn't listed there. only custom menu
item and custom button (with a smiley face)

help !


Johnny
 
While in Tools>Customize>Commands>Macros................

Drag Smiley Face up to a Toolbar.

Right-click on Smiley and "Assign Macro".

Choose from macro selection window.

Note you can also change Smiley to another Icon


Gord Dibben MS Excel MVP
 
Back
Top