Radio buttons

[malcmail]

I'm developing a sheet that has a number of yes no questions and decided on radio buttons as the best way to go. I had problems before with the forms control version so went for activeX. No problems grouping them and having them work nicely. Went off to develop some more of the sheet (just formulas etc) and now when I click on an option it won't change. Any ideas?

I went for ActiveX as the forms control, while allowing me to group buttons, didn't allow me to then hide the box around the buttons. If there is any way to do that I'm all ears as well. Thanks as always.

[Andy Pope]

Not in design mode are you?

Really depends on how your sheet looks as to whether you can make the form controls appear without a frame.

[malcmail]

Haha - nope. The only time it does anything is when it's in developer mode.

Am I right in saying you've hidden the frame behind a white box in that example? Clever, and would work for me with the colour scheme I'm running. Thanks for the help.

[Andy Pope]

yep, masked by a shape that colour match background

[malcmail]

Like your thinking. Thanks again.