An alternative to the student's method............

ToolsCustomizeCommands.

Scroll down to Macros and select.

From rightside pane drag the smiley face icon to a Toolbar.

Right-click on that icon and "assign macro".

You can also change the graphic by "change button image"


Gord Dibben MS Excel MVP

On Wed, 21 Nov 2007 05:57:01 -0800, Sue Parsons
wrote:

Hi,
How do i set up a new icon of my own and assign a macro to it?