Thread: Allow user to change the state of ("click" in) check-boxes on protected worksheets?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Cone Jim Cone is offline
external usenet poster
  
Posts: 3,290
Default 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


Reply With QuoteReply With Quote