Archive of Mr Excel Message Board


Back to Controls in Excel archive index
Back to archive home

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.

Re: Changing colour of form buttons

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


Re: Changing colour of form buttons

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


Re: Changing colour of form buttons

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.


Re: Changing colour of form buttons

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


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.