Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers
|
|||
|
|||
Cell locking trouble
I have a spreadsheet that needs to be "locked down" but it is a questionaire
styled sheet. Most of the questions on this sheet use radio button or check box selection and must be accessible by the user but there are also cells containing formulas which must be hidden/locked. I am able to specify the specific cells containing formulas as locked or unlocked, turn on protection with a password and access to those cells functions correctly. However, although I have individually selected each radio button and check box component and 'unlocked' them, when I turn on protection I get the following error when attempting to select them: "The cell or chart you are trying to change is protected and therefor read-only. To modify, blah blah blah..." I have attempted all combinations of "Select locked & unlocked" options on the Protect Sheet page but all return the same results when attempting to use the radio button and check box components. Any ideas? TIA, -Jeff |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers
|
|||
|
|||
Cell locking trouble
You have to unlock those linked cells, too. (Maybe hide them, too???)
Jeffery Tyree wrote: I have a spreadsheet that needs to be "locked down" but it is a questionaire styled sheet. Most of the questions on this sheet use radio button or check box selection and must be accessible by the user but there are also cells containing formulas which must be hidden/locked. I am able to specify the specific cells containing formulas as locked or unlocked, turn on protection with a password and access to those cells functions correctly. However, although I have individually selected each radio button and check box component and 'unlocked' them, when I turn on protection I get the following error when attempting to select them: "The cell or chart you are trying to change is protected and therefor read-only. To modify, blah blah blah..." I have attempted all combinations of "Select locked & unlocked" options on the Protect Sheet page but all return the same results when attempting to use the radio button and check box components. Any ideas? TIA, -Jeff -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell locking trouble
Jeff, If the radio buttons or checkboxes are linked to a cell, the linked cell needs to be unlocked. Cheers, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=487274 |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers
|
|||
|
|||
Cell locking trouble
That worked. Thank you.
"Dave Peterson" wrote in message ... You have to unlock those linked cells, too. (Maybe hide them, too???) Jeffery Tyree wrote: I have a spreadsheet that needs to be "locked down" but it is a questionaire styled sheet. Most of the questions on this sheet use radio button or check box selection and must be accessible by the user but there are also cells containing formulas which must be hidden/locked. I am able to specify the specific cells containing formulas as locked or unlocked, turn on protection with a password and access to those cells functions correctly. However, although I have individually selected each radio button and check box component and 'unlocked' them, when I turn on protection I get the following error when attempting to select them: "The cell or chart you are trying to change is protected and therefor read-only. To modify, blah blah blah..." I have attempted all combinations of "Select locked & unlocked" options on the Protect Sheet page but all return the same results when attempting to use the radio button and check box components. Any ideas? TIA, -Jeff -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell locking trouble
That worked. Thank you.
-Jeff "SteveG" wrote in message ... Jeff, If the radio buttons or checkboxes are linked to a cell, the linked cell needs to be unlocked. Cheers, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=487274 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Reference locking | Excel Discussion (Misc queries) | |||
trouble shoot pointing to a cell | Excel Worksheet Functions | |||
copying cell names | Excel Discussion (Misc queries) | |||
Cell locking and program freezing | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |