How do I hide the outline of a Forms Group Box?
 

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?

Hi MadTodd,

You can use VBA code to do this:

Sub HideGroupBox()
Dim Sh As Worksheet

Set Sh = ActiveSheet
Sh.GroupBoxes("Group Box 1").Visible = False

End Sub


Change Group Box 1 to the name of your groupbox.


---
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?

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?

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

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

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

Hi Dave,

Thank you for the additional information.

---
Regards,
Norman



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

Thanks for the help folks. I know just enough VBA to be dangerous at a
cocktail party, but nothing ventured nothing gained!

"Norman Jones" wrote:

Hi Dave,

Thank you for the additional information.

---
Regards,
Norman



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