Radio buttons unselected when file open

[gan_xl]

Hi,
Please see the attached file. I want the radio buttons unselected (like row 15) when it gets open. Could you please help me?

[davesexcel]

You can set the entire range to 0.

Call it in the worksheet_open event.

Please Login or Register  to view this content.

You may think about having a error checker, if you select more than one cell in the range you could get an overflow error. Just make it so you get kicked out of the selection_change event if you select more than on cell in that range.

Please Login or Register  to view this content.

[gan_xl]

Thank you so much. It is perfect.