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.

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.

Unlock the cells that the check boxes link to.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Gordon" wrote in message
...
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.