Adding a macro to a toolbar

D

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
 
A

~*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*~
 
B

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

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
 
U

user

Hello

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top