Hide Rows Containing Group Box and Check Boxes

[William777]

I am using Excel 2003. I had created a group box and 5 check boxes using Forms Toolbox. However, when I tried to hide the rows that contain a the group box and check boxes, the group box remains visible and the check boxes stack up on top of each other and are still visible. How can I hide the rows and the boxes? Thanks

Regards,
William

 

[Tazguy37]

Hiding rows won't affect controls that way, whether they are checkboxed, listboxes, whatever. They aren't part of the worksheet in the same way that cells are. It sounds like you'd have to use VBA to control the visibility of the checkboxes.

 

[zakasnak]

Do you have a sample code, Taz? I'm having the same problem, but am not as Excel-savvy as I pretend to be . . . LOL!