ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Reset default command button color (grey) in a form (https://www.excelbanter.com/excel-programming/385743-reset-default-command-button-color-grey-form.html)

Alex St-Pierre

Reset default command button color (grey) in a form
 
Hi,
I modify some BackColor of command button and depending what the user do, I
would like to put the same color as the initial color (grey). I tried the
following but it doesn't fit the grey in any Excel version (good with 2002
but not with 2003).
Me.CommandButton1.BackColor = RGB(212, 208, 200)
Is the a way to say something like:
Me.CommandButton1.BackColor = wdStandardCommandButtonColor
Thanks!
Alex
--
Alex St-Pierre

Tyla

Reset default command button color (grey) in a form
 
The line:
Me.CommandButton1.BackColor = &H8000000F&

seems to work fine on Excel 2003, Win 2003 SP2 in re-establishing the
default gray color for a button.

/ Tyla /

On Mar 20, 6:11 pm, Alex St-Pierre
wrote:
Hi,
I modify some BackColor of command button and depending what the user do, I
would like to put the same color as the initial color (grey). I tried the
following but it doesn't fit the grey in any Excel version (good with 2002
but not with 2003).
Me.CommandButton1.BackColor = RGB(212, 208, 200)
Is the a way to say something like:
Me.CommandButton1.BackColor = wdStandardCommandButtonColor
Thanks!
Alex
--
Alex St-Pierre





All times are GMT +1. The time now is 03:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com