Right click any toolbar
Select Customize
On the Commands tab select Macros from Categories
You'll see the custom button icon (smiley face) in Commands
Click it and drag it to your toolbar

--
Biff
Microsoft Excel MVP


"britt_04" wrote in message
...
How do you get to the "custom button" option? I can't find that anywhere?
I'm
trying to add a custom button to my toolbar and assign a macro to it, but
I
can't even find where to add the button?

Thanks!
-Brittany

"~*Amanda*~" wrote:

Dudley,

Drag and drop the button to where you want it on the toolbar, right click
that button (before closing the Customize dialog box) and select "Assign
Macro..." at the bottom of the list.

~*Amanda*~

"Dudley" wrote:

I want to add a macro to a toolbar, which I have done before but now it
does
not work so I must have forgotten something. I go to customise toolbars
and
then select 'commands' and 'macros'. The problem is that my macros are
not
shown, just 'Custom menu item' and 'Custom button'. How do I make my
macros
visible?

Thanks for any help.
Dudley