Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot table to calc by group | Excel Discussion (Misc queries) | |||
How do I hide the outline of a Forms Group Box? | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
border color in forms group box | Excel Discussion (Misc queries) | |||
Group buttons from the forms toolbar | Excel Discussion (Misc queries) |