| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Allow user to change the state of ("click" in) check-boxes on protected worksheets?
I know how to allow / deny users to change cell contents on a protected
worksheet ("Allow all users of this worksheet to select unlocked cells"), but unlocking check-boxes (on the Format Control / Protection tab) still prevents users from changing the state of a check-box if the sheet is protected, even if "Allow all users of this worksheet to select unlocked cells" is selected. Any ideas? Thanks! Chuck |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Allow user to change the state of ("click" in) check-boxes on protected worksheets?
Unlock the linked cell. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Chuck Zissman" wrote in message I know how to allow / deny users to change cell contents on a protected worksheet ("Allow all users of this worksheet to select unlocked cells"), but unlocking check-boxes (on the Format Control / Protection tab) still prevents users from changing the state of a check-box if the sheet is protected, even if "Allow all users of this worksheet to select unlocked cells" is selected. Any ideas? Thanks! Chuck |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Allow user to change the state of ("click" in) check-boxes on protected worksheets?
That did it: Thanks Jim!
"Jim Cone" wrote in message ... Unlock the linked cell. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Chuck Zissman" wrote in message I know how to allow / deny users to change cell contents on a protected worksheet ("Allow all users of this worksheet to select unlocked cells"), but unlocking check-boxes (on the Format Control / Protection tab) still prevents users from changing the state of a check-box if the sheet is protected, even if "Allow all users of this worksheet to select unlocked cells" is selected. Any ideas? Thanks! Chuck |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change "Windows User" in Comments box to my own name? | Excel Discussion (Misc queries) | |||
| "Control" plus "click" doesn't allow me to select multiple cells | New Users to Excel | |||
| Password-Protected Workbook not showing "in use by another user" | Excel Discussion (Misc queries) | |||
| Allow user to "switch" contents of two boxes in Excel | Excel Worksheet Functions | |||
| create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
Linear Mode
