Tick Box v Protection

[Gordon]

Hi...

I've got a worksheets filled with hundreds of tick boxes. If I protect the
sheet so the user cannot access my formulas etc then when they use a tick box
cells cannot be updated and I get told to unprotect the sheet.

How can all of my tick boxes work and yet my entire sheet be locked down and
fully protected?

Thanks in advance

Gordon.

 

[incre-d]

Create a second sheet with all your checkboxes linking to this second sheet
(perhaps hidden), then use formula on your base sheet to link to your new
sheet.

 

[Jon Peltier]

Unlock the cells that the check boxes link to.

- Jon