How do I label a command button so it doesn't say CommandButton1?

B

bstephens

How do I label a command button in Excel 2003? In Excel 97, when I last wrote
simple print macros, I used to be able to label the command buttons anything
I wanted to.
 
P

Paul B

You will have to be in design mode to do this, view, toolbars, control
toolbox, then click on the blue looking triangle to enter design mode, make
your changes and click it again, if you are just assigning a macro to a
button you may want to use a button from the forms toolbar, you can just
right click on it and change the caption.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Top