Option Button

[Cindy]

I've got 5 questions set up in a form in Excel where I
want to use the Option Button from the Forms menu.
So I set up 5 separate groups so the buttons would behave
independently within the groups. However, how do I get
rid of the border and the text "Group XX"?

 

[Dave Peterson]

I think you'll have to use a bit of VBA.

Option Explicit
Sub testme()
ActiveSheet.GroupBoxes.Visible = False
End Sub

Change it to True to see them again--nicer for developing.

==
If you don't use macros, you can select your sheet,
then hit alt-F11 (to get to the VBE)
then hit ctrl-G (to see the immediate window)
then type this and hit enter

ActiveSheet.GroupBoxes.Visible = False

(Same line as the macro.)