suznal


Is there a way with VBA to have a CheckBox with the enabled property set to false but defeat the "grayed out" quality.

I have checkboxes that take their value from other objects and I do not want the users to be able to select them, but I don't want them to look grayed out either.





Re: Excel CheckBox - Enabled "False" but I don't want it grayed out

Andy Pope


Hi,

Set the Locked property to TRUE.
You can change the value with code but not by clicking.






Re: Excel CheckBox - Enabled "False" but I don't want it grayed out

suznal

Setting the locked property to True did not do it, (all of mine are true by default anyway).

The only thing I have found useful with that property is that when the sheet is protected users cannot move the checkbox or access the properties (must unprotect the sheet first).







Re: Excel CheckBox - Enabled "False" but I don't want it grayed out

Andy Pope

The Locked property will only work if the control is on a userform.







Re: Excel CheckBox - Enabled "False" but I don't want it grayed out

suznal

These checkboxes are on worksheets...






Re: Excel CheckBox - Enabled "False" but I don't want it grayed out

suznal

I take it that it is not possible to acheive this




Re: Excel CheckBox - Enabled "False" but I don't want it grayed out

Andy Pope

Not that I know of.
You have to use sheet protection and the locked property.