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.

"Gordon" wrote:

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.