Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 . |
#4
|
|||
|
|||
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 . |
#5
|
|||
|
|||
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 . . |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet print including macro buttons? | Excel Discussion (Misc queries) | |||
Can a macro format a hidden sheet? | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) | |||
How do i print out my spreadsheet with macro buttons? | Excel Discussion (Misc queries) | |||
copy macro assigned buttons in an array | Excel Worksheet Functions |