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

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.

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

Right-click on the Command Button.
Select "CommandButton Object" then "Edit".

" wrote:

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.

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

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

"Elkar" wrote in message
...
Right-click on the Command Button.
Select "CommandButton Object" then "Edit".

" wrote:

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.