Thread: Tick Quandry
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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