Allow user to change the state of ("click" in) check-boxes on protected worksheets?


C

Chuck Zissman

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
 
Ad

Advertisements

J

Jim Cone

Unlock the linked cell.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Chuck Zissman" <[email protected]>
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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top