Buttons

  • Thread starter Thread starter Gary Thomson
  • Start date Start date
G

Gary Thomson

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
 
Back
Top