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 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