Assign a Macro
 

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

How do I do this?

regards

Assign a Macro
 

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

HTH

"The Rook" wrote:

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

How do I do this?

regards

Assign a Macro
 

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

--
Don Guillett
SalesAid Software

"The Rook" wrote in message
...
I am wanting to place a button on a speadsheet and assign a macro to it.

How do I do this?

regards

Assign a Macro
 

thanks
an excellent tip
--
Gary's Student
gsnu200707


"Don Guillett" wrote:

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

--
Don Guillett
SalesAid Software

"The Rook" wrote in message
...
I am wanting to place a button on a speadsheet and assign a macro to it.

How do I do this?

regards

Assign a Macro
 

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

right click the menu barcustomizecommandsautoshapesselect and drag to
menu bar

--
Don Guillett
SalesAid Software

"Gary''s Student" wrote in message
...
thanks
an excellent tip
--
Gary's Student
gsnu200707


"Don Guillett" wrote:

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

--
Don Guillett
SalesAid Software

"The Rook" wrote in message
...
I am wanting to place a button on a speadsheet and assign a macro to it.

How do I do this?

regards

Assign a Macro
 

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


"Don Guillett" wrote:

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

right click the menu barcustomizecommandsautoshapesselect and drag to
menu bar

--
Don Guillett
SalesAid Software

"Gary''s Student" wrote in message
...
thanks
an excellent tip
--
Gary's Student
gsnu200707


"Don Guillett" wrote:

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

--
Don Guillett
SalesAid Software

"The Rook" wrote in message
...
I am wanting to place a button on a speadsheet and assign a macro to it.

How do I do this?

regards