View Single Post
  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

And if there aren't too many...

ActiveSheet.GroupBoxes.Visible = False

(I'm not sure how many is too many, though.)



Norman Jones wrote:

Hi MaddTodd,

And to hide all the groupboxes, try:

Sub HideAllGroupBoxes()
Dim Sh As Worksheet
Dim gBox As GroupBox
Set Sh = ActiveSheet

For Each gBox In Sh.GroupBoxes
gBox.Visible = False
Next gBox

End Sub

---
Regards,
Norman

"MadTodd" wrote in message
...
I am using a couple of groups of option buttons but would prefer not to
show
the actual box around the group. Is there a way to hide the outline?


--

Dave Peterson