Tick Quandry
 

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

Tick Quandry
 

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.
--
HTH...

Jim Thomlinson


"Gordon" wrote:

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