In an Excel file, I have two radio buttons in a group. I need for people to click one or the other. However, I need to protect the whole worksheet. When I protect the worksheet the radio buttons cannot be clicked. I have unprotected them, but they still won't allow the user to click them.
How can I protect the worksheet, but allow for the radio buttons to be clicked?
Nope, not is design mode. And all cell attributes are unlocked. Yet everytime I try to protect the worksheet the radio button are not accessible. I'm just not understanding what I'm doing wrong : (