Hi Dave,

ActiveSheet.GroupBoxes.Visible = False

The difference is that the OP is paying *me* by the word!


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

Are you aware of such a limit and, if so, do you know if it is a limit on
the number of objects which can be handled in a pass, or a limitation on the
number of objects?


---
Regards,
Norman



"Dave Peterson" wrote in message
...
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