View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default Protected Object

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?