Format Macro Buttons?

Excel 2000 ... I only record Macros & I create Macro
Buttons using the "Forms" Tool Bar ... I can edit text &
change Font color, but how do I change the "gray" color of
the button itself. I have gone to "Format Control", but I
see no option here to accomplish this ... Unless of course
I am overlooking it which is often the case ...

Above said ... How do I format the "color" &/or "shape" of
my Macro Buttons? ... Thanks ... Kha

You cannot change the color of a Forms toolbar button. You can assign a
macro to an object that you can color, like a Drawing toolbar autoshape or
rectangle, etc., or use a Control Toolbox command button.

--
Jim Rech
Excel MVP
"Ken" <[email protected]> wrote in message
news:[email protected]...
| Excel 2000 ... I only record Macros & I create Macro
| Buttons using the "Forms" Tool Bar ... I can edit text &
| change Font color, but how do I change the "gray" color of
| the button itself. I have gone to "Format Control", but I
| see no option here to accomplish this ... Unless of course
| I am overlooking it which is often the case ...
|
| Above said ... How do I format the "color" &/or "shape" of
| my Macro Buttons? ... Thanks ... Kha

hi,
in the button's property sheet, change the button's back
color.
>-----Original Message-----
>Excel 2000 ... I only record Macros & I create Macro
>Buttons using the "Forms" Tool Bar ... I can edit text &
>change Font color, but how do I change the "gray" color
of
>the button itself. I have gone to "Format Control", but
I
>see no option here to accomplish this ... Unless of
course
>I am overlooking it which is often the case ...
>
>Above said ... How do I format the "color" &/or "shape"
of
>my Macro Buttons? ... Thanks ... Kha
>.
>

The Forms toolbar background color can't be changed.

You could use the commandbutton from the control toolbox toolbar, though.

Or even better, show the Drawing toolbar and make a shape as complex as you want
and assign the macro to it.



Ken wrote:
>
> Excel 2000 ... I only record Macros & I create Macro
> Buttons using the "Forms" Tool Bar ... I can edit text &
> change Font color, but how do I change the "gray" color of
> the button itself. I have gone to "Format Control", but I
> see no option here to accomplish this ... Unless of course
> I am overlooking it which is often the case ...
>
> Above said ... How do I format the "color" &/or "shape" of
> my Macro Buttons? ... Thanks ... Kha

--

Dave Peterson

You are referring to a button from the Control Toolbox, right? He said he's
using the button from the Forms toolbar.

On Wed, 2 Mar 2005 11:46:47 -0800, <[email protected]>
wrote:

>hi,
>in the button's property sheet, change the button's back
>color.
>>-----Original Message-----
>>Excel 2000 ... I only record Macros & I create Macro
>>Buttons using the "Forms" Tool Bar ... I can edit text &
>>change Font color, but how do I change the "gray" color
>of
>>the button itself. I have gone to "Format Control", but
>I
>>see no option here to accomplish this ... Unless of
>course
>>I am overlooking it which is often the case ...
>>
>>Above said ... How do I format the "color" &/or "shape"
>of
>>my Macro Buttons? ... Thanks ... Kha
>>.
>>

opps. that part when right over my head.
he would have posted back and i would have caught it then.
but thanks for catching me on that one.

>-----Original Message-----
>You are referring to a button from the Control Toolbox,
right? He said he's
>using the button from the Forms toolbar.
>
>On Wed, 2 Mar 2005 11:46:47 -0800,
<[email protected]>
>wrote:
>
>>hi,
>>in the button's property sheet, change the button's back
>>color.
>>>-----Original Message-----
>>>Excel 2000 ... I only record Macros & I create Macro
>>>Buttons using the "Forms" Tool Bar ... I can edit text
&
>>>change Font color, but how do I change the "gray" color
>>of
>>>the button itself. I have gone to "Format Control",
but
>>I
>>>see no option here to accomplish this ... Unless of
>>course
>>>I am overlooking it which is often the case ...
>>>
>>>Above said ... How do I format the "color" &/or "shape"
>>of
>>>my Macro Buttons? ... Thanks ... Kha
>>>.
>>>
>
>.
>