Help! I can't unlock my radio buttons!

[dbritner]

I have 4 radio buttons that when selected enter #1-4 in a hidden cell. The answers 1-4 then allow me to use IF formulas to create dependant data in ajacent cells. The problem is, when I protect the worksheet, the radio buttons are locked and I get an error msg. These are not linked to cells, but I unlocked the cells they are over, and I've unlocked the buttons themselves, but this has not solved the problem. I am using a trial version of 2007, but have saved it in a 2003 compatible file. I edit using both versions depending on my location.

Thanks,
dbritner

 

[dbritner]

Fixed- was linked cell (1-4) duh - unlocked this cell and it worked. I do have a secondary problem though. As soon as I got that working, then the click buttons in the same calculator stopped working when sheet is protected. They were working... oy.