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" wrote in 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

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

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
.


.