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

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