Is there any property to hide the border of a xlGroupBox?

[kishor_ys]

Here is the sample code

Set sGroupBox = Sheets(1).Shapes.AddFormControl(xlGroupBox, _
Cells(1, 2).Left, Cells(1, 2 + 1).Top, 200, 16)
sGroupBox.TextFrame.Characters.Text = ""

which creates a group box with thin border.

Is there any property to hide the border of a group box?

 

[Jon Peltier]

This requires some faking, since Excel doesn't let us access the groupbox's border. You need your groupbox, a rectangle, and your option buttons. Draw the rectangle so it is slightly larger than the groupbox, give it a fill color to match the background, and remove its border. Set the stacking order of the objects so the group box is under all other objects, the rectangle is next, and all the buttons are on top.

 

[brites]

I just had the same problem and found this solution:

You dont need a macro, just a code.

Hit alt-f11 to get to the VBE
hit ctrl-G to see the immediate window

type this in and hit enter:
activesheet.groupboxes.visible = false

This hides all the groupboxes on the activesheet.

If you are running excel2007 it means you dont even need to save as a macro workbook, a regular file will do it.

Cheers!