Hi,

not sure if this is the correct forum, but here goes
anyway:

I have a Macro which works on a particular sheet. In that
sheet I want to put a "button", so that when the user
clicks on that button, the macro is invoked.

How do I "draw" the button, and how do I assign the macro
to it??

Many Thanks,

Gary Thomson.

Gar
on forms toolbar there is "button" icon (light grey rectangle) which you can drag to required cell then right click mouse and assign macro to it

Tin

Gary

You can also make a clickable button out of almost anything and assign a macro
to it.

Text box with text, Word Art object, drawing objects, an inserted graphic.

Gord Dibben Excel MVP

On Wed, 3 Mar 2004 03:41:05 -0800, "Tina"
wrote:

Gary
on forms toolbar there is "button" icon (light grey rectangle) which you can drag to required cell then right click mouse and assign macro to it.

Tina