Create a button and assign a macro to it?

randy__6

New Member
Joined
Aug 17, 2006
Messages
13
I've written a macro and have been using it with the ctrl+ shortcut. Now I would like to create a button and assign the macro to it. How do I do that?
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

You can draw a button from the Forms toolbar. When you're done you'll get a menu. Chose the Assign Macro option and select your macro from the list.

Hope that helps,

Smitty
 

randy__6

New Member
Joined
Aug 17, 2006
Messages
13
Tried that...didn't work. Then I restarted excel and tried it again...worked.

Thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,114,041
Messages
5,545,685
Members
410,697
Latest member
srishtijain0708
Top