View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chuck Zissman Chuck Zissman is offline
external usenet poster
 
Posts: 2
Default 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