Protected Object

[Guest]

I have a Check Box on a sheet that I created from the Control ToolBox. I am
trying to protect the sheet but not these check boxes. I have set up a range
for the results of the checking that is unprotected. I also set up a
protection-free range for the area the checkboxes occupy and I have
specifically said to allow objects to be free from protection but when I have
protection on and click a check box, I get this:

"The cell or chart you are trying to change is protected and therefore
read-only." It goes on to tell me what to do. But I don't know what else to
do.

 

[JW]

I have a Check Box on a sheet that I created from the Control ToolBox. I am
trying to protect the sheet but not these check boxes. I have set up a range
for the results of the checking that is unprotected. I also set up a
protection-free range for the area the checkboxes occupy and I have
specifically said to allow objects to be free from protection but when I have
protection on and click a check box, I get this:

"The cell or chart you are trying to change is protected and therefore
read-only." It goes on to tell me what to do. But I don't know what else to
do.

Have you right-clicked on the checkbox and selected Format Control and
then unchecked Locked on the Protection tab?

 

[Guest]

I forgot to mention that I did that also. I did NOT unlock the text too, but
that didn't seem necessary. Any other ideas?

 

[Dave Peterson]

Check the location of that linked cell once more. And check to see if that
linkedcell is locked.

(Could be a typo in the address of that linkedcell????)

 

[Guest]

I rechecked that. I put a break on the macro that the button calls and the
message comes up even before the macro begins to execute.

 

[Guest]

I was wrong. The object is from the Form Toolbox not the Control Toolbox.
The Control Toolbox checkbox will work okay with the protection on. But
unlike the form Checkbox, if I change the value of the reference cell the
checkbox doesn't automatically change as it does with the Form Toolbox. I
hate to change as I have several buttons but I can't seem to solve this
issue. Anybody have any ideas?

 

[Dave Peterson]

I couldn't duplicate your situation.

I put a checkbox from the Forms toolbar on a worksheet.
I assigned A11 as the linked cell (unlocked).

I put a checkbox from the Control toolbox toolbar on a worksheet.
I assigned A12 as the linked cell (also unlocked).

I protected the worksheet.

I could type true or false in either cell and the corresponding checkbox checked
or unchecked.

But there was a difference when I had calculation set to manual. The checkbox
from the control toolbox toolbar didn't update until I recalculated.

Any chance that's your situation.