Adding a macro to a toolbar

[Dudley]

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

 

[~*Amanda*~]

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]

That works fine. Thanks very much for your help.

Dudley

 

[britt_04]

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

 

[T. Valko]

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

 

[user]

Hello

When I right-click to assign macro, nothing happens. What am I doing wrong?
Please help.

 

[user]

How do I assign multiple macros to my custom toolbar?

 

[Dave Peterson]

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

In xl2007, those toolbars and menu modifications will show up under the addins.

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm