disabled check boxes
 

I used check box in excel. Is there a way to disable the check box without
protecting the entire sheet?

Hi there,

Not sure i totally understand what you are asking, is it that you
simply do not want the result of the check box to be recorded in your
worksheet?

If this is the case then simply right-click on the checkbox and select
format_control.. then delete anything that is in the cell link box.
Doing this will ensure that if anyone tries to check the box the
results will not be recorded.

If however you simply do not want them to be able to select the
checkbox, you could simply draw a box the same shape as the check box
and position it on top of the checkbox. If you format the box so that
there is no fill and no lines then it will appear invisible.(remember
the box need to be on top of the check box)

I Hope this helps you, if this is not quite what you meant then please
let me know

Best regards,

Rob Turnbull
*Sortoutmyexcel.com*


--
Rob Turnbull
------------------------------------------------------------------------
Rob Turnbull's Profile: http://www.excelforum.com/member.php...o&userid=24278
View this thread: http://www.excelforum.com/showthread...hreadid=380216

Chinita,

Is the checkbox from the Forms toolbar or the Controls Toolbox toolbar? Do
you want it disabled automatically in certain situations, or do you want to
disable it manually? For the former, it will require macro code. To
manually disable a checkbox, if it's from the Controls Toolbox toolbar, put
it in design mode (upper left button in Controls Toolbox),. right-click the
checkbox, select "properties," and set the "enabled" property to false.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"chinita" wrote in message
...
I used check box in excel. Is there a way to disable the check box without
protecting the entire sheet?

Rob,

I think he want's it to be "greyed out," indicating to the user that it's
not usable under the current conditions. When it's disabled, it turns gray,
and it can't be clicked. Well, it can, but it doesn't do anything - its
checked state doesn't change. Disabling can be done with macro code,
including event code, which gets run automatically when cells are updated,
sheets are changed, or whatever. We'll see what he has to say if he posts
back about his requirements.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Rob Turnbull"
wrote in message
news:Rob.Turnbull.1qtuyd_1119107105.2215@excelforu m-nospam.com...

Hi there,

Not sure i totally understand what you are asking, is it that you
simply do not want the result of the check box to be recorded in your
worksheet?

If this is the case then simply right-click on the checkbox and select
format_control.. then delete anything that is in the cell link box.
Doing this will ensure that if anyone tries to check the box the
results will not be recorded.

If however you simply do not want them to be able to select the
checkbox, you could simply draw a box the same shape as the check box
and position it on top of the checkbox. If you format the box so that
there is no fill and no lines then it will appear invisible.(remember
the box need to be on top of the check box)

I Hope this helps you, if this is not quite what you meant then please
let me know

Best regards,

Rob Turnbull
*Sortoutmyexcel.com*


--
Rob Turnbull
------------------------------------------------------------------------
Rob Turnbull's Profile:
http://www.excelforum.com/member.php...o&userid=24278
View this thread: http://www.excelforum.com/showthread...hreadid=380216