Worksheet Button Color

[Jaye7]

Hi,

Can someone please provide a script that will change a commandbutton on my worksheet from the dull grey to the light orange color.

And another script that will change all buttons on a sheet to light orange.

Thanks.

 

[grizz]

You dont have a lot to choose from if its from control tool box and nothing from a forms command button but if you go to
Insert / Picture / Auto Shapes and make a very good command button -- you can assign Macro and you have a list of colours to choose from

 

[Jaye7]

Thanks Grizz, I didn't think about using an autoshape instead.