The color of a push button

[Bobby]

I created a button on a sheet to accomplish a certain task. I am able
to change the text color but not the button it self(which is by the
way, gray). I use Excel 2000. Can anyone help?
Thank's ahead.

 

[Paul B]

Bobby, if its from the forms toolbar I don't think it can be changed, if its
from the control toolbox you can change the background color in properties
--
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

 

[Bernard Liengme]

Did you make the button from the Forms tool?
Try using the button from Control Toolbox; after making it right click and
open Properties. Now you can change the Background colour
best wishes

 

[Bobby]

Paul, I did create the button from the
toolbar(TOOLS->PERSONALIZE->TOOLBAR->and then select FORMS) . I have
looked at all options can't find a background color properties for a
button.

 

[Paul B]

Bobby, as I said the buttons form the forms toolbar can not be changed, use
a command button, view, toolbars, control tool box, drag a button to your
sheet and right click on it, properties, back ground color

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

 

[Don Guillett]

Or, you might prefer using a shape instead.

 

[Bobby]

Paul, thank's for the info. I am new to the newsgroup, how I response
to the newsgroups so others can benefit from it ?

 

[Bobby]

Don G. thanks to you to for the info.

 

[Paul B]

Bobby, have a look at these sites for more information on newsgrups

http://www.cpearson.com/excel/newposte.htm

http://www.mvps.org/dmcritchie/excel/xlnews.htm

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