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

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

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

While in ToolsCustomizeCommandsMacros................

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

On Sat, 25 Sep 2010 15:32:19 -0700 (PDT), Johnnyboy5
wrote:

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