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.
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.
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
"Bobby" <[email protected]> wrote in message
news:[email protected]...
>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.
>
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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Bobby" <[email protected]> wrote in message
news:[email protected]...
>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, 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.
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
"Bobby" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
Or, you might prefer using a shape instead.
--
Don Guillett
SalesAid Software
[email protected]
"Bobby" <[email protected]> wrote in message
news:[email protected]...
> 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, thank's for the info. I am new to the newsgroup, how I response
to the newsgroups so others can benefit from it ?
Don G. thanks to you to for the info.
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
"Bobby" <[email protected]> wrote in message
news:[email protected]...
> Paul, thank's for the info. I am new to the newsgroup, how I response
> to the newsgroups so others can benefit from it ?
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks