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! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If you open the workbook with macros disabled, then your code that unhides them
won't run. Open the workbook with macros enabled and then make your change ("= true") and then run the macro to see if that works. Newbeetle wrote: 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! -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Dave,
I tried that but still can't see them, I can select and drag the radial buttons out of the box, and when I put them back in the rough area they work as before so the Groupbox is still there, has me baffled. -- This post was created using recycled electrons! "Dave Peterson" wrote: If you open the workbook with macros disabled, then your code that unhides them won't run. Open the workbook with macros enabled and then make your change ("= true") and then run the macro to see if that works. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Dave,
Its started to behave itself after a reboot, but for the life of me not sure what the problem was, thanks for the advice as always. -- This post was created using recycled electrons! "Dave Peterson" wrote: If you open the workbook with macros disabled, then your code that unhides them won't run. Open the workbook with macros enabled and then make your change ("= true") and then run the macro to see if that works. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Glad you got it working--no matter how!
Newbeetle wrote: Hi Dave, Its started to behave itself after a reboot, but for the life of me not sure what the problem was, thanks for the advice as always. -- This post was created using recycled electrons! "Dave Peterson" wrote: If you open the workbook with macros disabled, then your code that unhides them won't run. Open the workbook with macros enabled and then make your change ("= true") and then run the macro to see if that works. -- Dave Peterson |
Reply |
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) |