I have set up a spread sheet with grouped radio buttons that toggle between yes and no depending on the value in a linked cell. The sheet is protected. If someone clicks on the button that is not selected based on the formula in the linked cell, firstly the error message pops up that the cell is protected but secondly the button that was previously selected becomes unchecked leaving both buttons unchecked. This happens even though the formula in the linked cell is still showing the same value. If I click on the button that was selected before the error message, the selection again becomes visible. Is there some code or property that will allow the button to be refreshed after the error message automatically?