Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
100% quandry | Excel Discussion (Misc queries) | |||
Another hyperlink quandry: | Excel Programming | |||
COUNTIF quandry | Excel Worksheet Functions | |||
Macro Quandry | Excel Discussion (Misc queries) | |||
SQL Query Quandry | Excel Programming |