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
 
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
 

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

Similar Threads

when I protect a worksheet, user cannot use check boxes 4
using Spell check on protected sheet 6
I can still select & manipulate locked & protected cells in '07 1
Sorting Protected Worksheet 4
allow a user to edit ranges in a protected worksheet 3
hide columns on a protected sheet 2
Excel 2002 "Protect Sheet", but Allow "Insert Comments"? 2
Protect sheet but allow sorting only 4

Top