Thread: Forms Group Box
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Newbeetle Newbeetle is offline
external usenet poster
 
Posts: 98
Default Forms Group Box

Hi I used the following code from an old post below to hide group boxes and
it works a treat. (this has been placed in ThisWorkbook)

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


Question, when I open the workbook turning macro's off I cant then see the
groupboxes? I tried changing the statement above to gBox.Visible = True and
opening with macro's but I still cant see them,

So how do I go about seeing them again?

--
This post was created using recycled electrons!