Put a button on an Excel worksheet
I love the form tools in Excel they let you do so many cool things. One thing I love to do is to make buttons run my macros. To do this, use the Forms toolbar, click the Button tool and drag to create a button on the worksheet. When you do, a dialog appears with all your macros listed so you can select the one to use. You can also edit the text on the button and when you're done simply click it to run the macro - sweet huh?
If you're using Excel 2007 you have to add the button tool to your Quick Access toolbar (it's in the Commands Not In The Ribbon group and it's called Button (Form Control).
Labels: button, Excel 2003, Excel 2007, Form control
posted by Jane @ 11:42 AM
7 Comments:
Many Thanks!
After digging though Excel's so called help I had to hit the net, your's was right at the top and the perfect answer to my question! (Adding a button to a worksheet!)
Thanks. Its a simple thing but so lil help is available. You answered that.
Not quite complete. Using Office 2007, you must first activate the Controls Ribbon, as described here: http://support.microsoft.com/kb/291073
Not quite complete. Using Office 2007, you must first activate the Controls Ribbon, as described here: http://support.microsoft.com/kb/291073
What if you're using Excel 2003?
Is there anything similar or have you got to use macros to create the buttons?
How do you change the name of the button to something more meaningful than Button1?
To rename the button, right click the button and choose Edit text.
In Excel 2003, the button can be found on the Forms toolbar, choose View > Toolbars > Forms to see it.
Post a Comment
Please feel free to add your comment here. Thank you!
Subscribe to Post Comments [Atom]
<< Home