MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Changing colour of form buttons


Posted by Brian M. on April 17, 2001 1:59 AM

Is it possible to change the colour of buttons on forms? I realise that I can change the text format but don't appear to have any way of changing the color from grey.


Posted by Dave hawley on April 17, 2001 2:31 AM


Hi Brian

I assume you mean CommadButtons ? Right click on them and then from the Properties Window select:
"BackColor"


Dave


OzGrid Business Applications

Posted by Dave hawley on April 17, 2001 2:31 AM


Hi Brian

I assume you mean CommadButtons ? Right click on them and then from the Properties Window select:
"BackColor"


Dave


OzGrid Business Applications

Posted by Brian M. on April 17, 2001 3:14 AM

I mean the buttons that you get from the forms toolbar used for running macros.

Posted by Dave Hawley on April 17, 2001 4:01 AM


Brian, these buttons are limited in what they can do so I would suggest using a CommandButton from the "Control Toolbox" toolbar instead. Then set the "BackColor" in the Properties Window. I would also set the "TakeFocusOnClick" to False as well to avoid other problems.

Dave
OzGrid Business Applications