Problem with protection of sheet that includes radio buttons

Topic

New Reply

I have a small spreadsheet that does calculations based on input of selected cells and the selection of radio buttons. This worked just fine when I made it in 2006. Now I have added to it and can not protect it the way it was. All cells were protected except those that may require input and the 6 radio buttons.

Now I can not unlock my radio buttons.. What have I forgotten to do?

The buttons were made from the Visual Basic Editor. If I go to Design Mode select one of the buttons under properties they are listed as: locked false. On an original.. that I did not modify, the property on that is the same. Changing the locked property to true does not fix the problem.

Here is what I am doing > select all > format >cells > select locked and hidden. Then select all those cells I want available for input > format >cells > deselect locked and hidden. Then Tools >Protection > Protect sheet. select option to access unlocked cells.

Now it works.. except I can not use my radio buttons and get double error messages when I do.

Thanks for your time.. and any thoughts as to what I am forgetting to do appreciated

Reply | Quote

Replies

Are the cells linked to the buttons locked? They must be unlocked so that they can be changed…

Steve

Reply | Quote

Thanks Steve
That was the problem:blush:. My buttons set up a true / false thing and those cells were locked.

Thanks again

Reply | Quote