Button Color (Excel 2000)

[catoothaker]

Hi ... this is rather minor (but you know users) .... Is it possible to change the color of a button on a worksheet. This button was created simply using the button on the Forms toolbar and I use these buttons to activate macros. I know I can change font color. Can the button itself change color. Thanks.

[rory]

Hi,
You can change the colour but you'd have to change the Windows Desktop settings to do it and it would have some (probably unpleasant) side effects!
Alternatively if you use the Command button from the control toolbox, you can change the BackColor property of that quite easily.
Hope that helps.

[BobUmlas]

Yes -- instead of using the button on the forms toolbar, use the button from the control box toolbar. Then, right-click the button & bring up Properties window where you'll find you can change the forecolor/backcolor of the button. Right-click again for the View Code to associate it with code.