Assign a Macro

[Guest]

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

How do I do this?

regards

 

[Guest]

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

HTH

 

[Don Guillett]

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

 

[Guest]

thanks
an excellent tip

 

[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

 

[Guest]

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