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.