buttons

  • Thread starter Thread starter ginnyt
  • Start date Start date
G

ginnyt

How do you put a button on a worksheet in Excell XP? I
searched Help & all it gives is the way to put a button on
a toolbar.
 
What kind of button? You can insert a button that will run a macro from the Forms toolbar

tj
 
Just to add to tjtjjtjt's answer:

You can do View|toolbars and show the Forms toolbar and the Control toolbox
toolbar. Each of these has a button that you can drop on a worksheet--but they
behave differently.

If you use the controltoolbox commandbutton, you can double click on that button
and put your code inside that procedure that appears.

If you use the button from the Forms toolbar, you can put your code in a general
module and assign that macro to the button (either right after you place the
button--or by rightclicking and choosign Assign macro).
 
ginnyt

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
 
You must log in or register to reply here.

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

Excel 2003 - assign macro to custom toolbar button 1
Excel 2007 -- Assign a macro to a button 1
Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons? 1
custom toolbar item to use hyperlink to open word file 2
'Cannot insert object' message when I try to put a button on a worksheet 7
Font Size of Radio Buttons 2
Printing Option Buttons 6
Macro Buttons 3

Back
Top