Tick Quandry

[Gordon]

Hi...

I want to protect my sheets from any changes but I can't do this if I use a
tick box. Therefore, I leave cells unprotected which I'd rather not do.

Any solutions?

Thanks

G

 

[Jim Thomlinson]

If you are using XL 2002 or better then you have some options when you
protect a sheet. One of the options is to allow users to edit objects. If you
check that off then the users can still access the tick boxes.