Assign a Macro

G

Guest

I am wanting to place a button on a speadsheet and assign a macro to it.

How do I do this?

regards
 
G

Guest

Go to FORMS toolbar, select button, place on worksheet and it will
automatically ask you to assign a macro.

HTH
 
D

Don Guillett

In addition to the forms toolbar I usually use shapes from the drawing
toolbar.
 
D

Don Guillett

I have the rectangle from the "drawing shapes" toolbar.

right click the menu bar>customize>commands>autoshapes>select and drag to
menu bar
 
G

Guest

It's just really cool to realize you can make just about any piece of clipart
into a macro activcation button!
 

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

Similar Threads

Format a macro button 2
Excel 2007 -- Assign a macro to a button 1
macro does not assign to menu? 2
Assign a macro to the save button 4
Assign Macro Dialog Box 6
Assign a macro to a button 4
Assign different macros for True/False button 2
How to assign macro coding into customized button? 4

Top