Macro Button Colors for Excel 2007

[lcolson]

How do I edit or change the Macro Button Face color in Excel 2007. I had the capability in Office XP, but I cant find a way with 2007 yet. I can change the Font color, but not the button face color. Can someone help?

Thanks,
LC

 

[Peter_SSs]

How do I edit or change the Macro Button Face color in Excel 2007. I had the capability in Office XP, but I cant find a way with 2007 yet. I can change the Font color, but not the button face color. Can someone help?

Thanks,
LC

Can you explain just what you mean by 'the Macro Button'?

 

[lcolson]

I'm referring to the command button to run the macro. I have added it to my worksheet. It is grey. In Excel 2003 I could change the color of the button so it stands out more. With Excel 2007, I am only able to change the color of the font, not the color of the button itself.

I hope this helps,
Larry

 

[Peter_SSs]

I'm referring to the command button to run the macro. I have added it to my worksheet.

From where? Form Controls? ActiveX Controls? Something else?

If ActiveX, then can you right click, choose 'Properties' and change the 'BackColor' property?

If not ActiveX, then what sort of button and how did you change the colour in Excel 2003?

 

[lcolson]

FORM CONTROL. I go to the Developer tab, then Insert, but my Active X buttons are not highlighted and I cannot access them for some reason in that worksheet.

 

[Peter_SSs]

You didn't say how you coloured these Form Control Command Buttons in Excel 2003? Or were you using Control ToolBox Command Buttons then?

In Excel 2007, have a look here:
Office button|Excel options|Trust Center|Trust Center Settings|ActiveX Settings
Maybe you have 'Disable all...'?
Have a look in the built-in Help if you need more info about this.

 

[lcolson]

Thanks Peter, I'll check it out