I have a 3 sheet excel file with protection on all 3 sheets (let's call
them A, B and C). These 3 pages have formulas that link to each other.
Sheet A has a few checkboxes that link to sheet C. The problem is that
when I try to check any of the check boxes on sheet A an error box pops
up that says "The cell or chart you are trying to change is protected
and therefore read only". Is there a way to protect a sheet while being
able to check a box off that is linked to another sheet? What protection
options would allow me to do this?

Thanks in advance.
Dave


--
Dave123
------------------------------------------------------------------------
Dave123's Profile: http://www.excelforum.com/member.php...o&userid=27748
View this thread: http://www.excelforum.com/showthread...hreadid=472581

If you unprotect sheetC, then unlock those cells that are linked back to the
checkboxes on sheetA, then reprotect sheetC, does it work?

Dave123 wrote:

I have a 3 sheet excel file with protection on all 3 sheets (let's call
them A, B and C). These 3 pages have formulas that link to each other.
Sheet A has a few checkboxes that link to sheet C. The problem is that
when I try to check any of the check boxes on sheet A an error box pops
up that says "The cell or chart you are trying to change is protected
and therefore read only". Is there a way to protect a sheet while being
able to check a box off that is linked to another sheet? What protection
options would allow me to do this?

Thanks in advance.
Dave

--
Dave123
------------------------------------------------------------------------
Dave123's Profile: http://www.excelforum.com/member.php...o&userid=27748
View this thread: http://www.excelforum.com/showthread...hreadid=472581

--

Dave Peterson