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.

On Sep 21, 7:12 am, Mike H. wrote:
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?

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?

"JW" wrote:

On Sep 21, 7:12 am, Mike H. wrote:
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?

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????)

Mike H. wrote:

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.

--

Dave Peterson

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.

"Dave Peterson" wrote:

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????)

Mike H. wrote:

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.

--

Dave Peterson

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?

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.



Mike H. wrote:

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