Forum Discussion
Radio Butto Protection
Hello everybody,
I would like to protect a worksheet so that it is possible to select radio buttons, but not to move or edit these radio buttons. Is there a way to do this?
It looks like only the opposite is possible - I can protect the fields so that they can be moved and edited, but not selected! That would be absolutely ridiculous, because there is no use case for this constellation!
Thanks for any tips.
Regards
Matthias
4 Replies
When you protect the sheet, do not tick the check box 'Edit Objects'.
Users should then be able to click option buttons, but not edit, move or delete them.
Many thanks for the feedback! Yes, I also thought it should work that way. But as mentioned above, I cannot select options then! If I ticked the check box ‘Edit Objects’, I could edit, move or delete the radio buttons, but still not select any options!
As soon as I try to select an option on a protected sheet (regardless of the selected protection boxes), I get the following error message:
‘The cell or chart you're trying to change is on a protected sheet. To make a change, unprotect the sheet. You might be prompted for a password.’
Stupid, isn't it?
Thanks anyway and best regards!
If the radio button is linked to a cell, that cell should be unlocked.
That is because clicking the radio button will change that cell's value, and that will fail if the cell is locked.
