C
chinita
I used check box in excel. Is there a way to disable the check box without
protecting the entire sheet?
protecting the entire sheet?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rob Turnbull
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*
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*
E
Earl Kiosterud
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.
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.
E
Earl Kiosterud
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.
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.