techwriterAR
MIS
I have an excel 2003 spreadsheet with 21 group boxes and each group box has 5 option buttons. (NOTE: I am using the Form Control toolbar, not the Control toolbar.) Each group box is linked to one cell and displays the number of the option button selected. All the group boxes work this way and all the option buttons work as expected - when one button in the group is clicked the others are empty. Each group box is independent of the others. The problem is I want to protect this spreadsheet so the user can only enter in certain unlocked cells. These cells are for entering names, titles, dates, comments, etc, and the option buttons. I have unlocked the group boxes, each individual option button, the cell the option button is in, and the cells between each option button. When I turn protection on and click an option button, I get a message that I cannot touch that cell because it is protected. Can someone please tell me what I am doing wrong??