Protection Problem

  • Thread starter Thread starter Dave123
  • Start date Start date
D

Dave123

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
 
If you unprotect sheetC, then unlock those cells that are linked back to the
checkboxes on sheetA, then reprotect sheetC, does it work?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Password Protection 2
Excel Move or Copy Stopped Working? 0
Trying to unprotect Checkboxes 2
protect unprotect toggle VBA 6
Unprotect Combo Box in a Protected Sheet 3
Sheet protection problem 1
Protected worksheet allow users 1
hide columns on a protected sheet??? 1

Back
Top