I am aware that a limit exists when working with shapes/objects.

But I'm not sure what that limit is (or if it's a hard limit--or if it depends
on what's in use (memory??)).

I do know that the single line fails when there are lots (and quite a few people
have lots of shapes in worksheets based on posts around here).

I've never seen your looping code fail.

I'm not sure I understand the second portion. Since it's a one liner, I'm
guessing that it's based on the number of objects, since there's only one pass
(did that make sense???).



Norman Jones wrote:

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

--

Dave Peterson