Grouped Row Properties ?

[jeremymc7]

I need to change the properties for grouped rows. Where are their properties (VBA?) and how do I change then.

I have a complex sheet that keeps several sections grouped (and collapsed) on the screen for data input unless it's needed, then they're expanded.

When we print a hard copy for records I'd like to force printing the collapsed sections even if they're collapsed on the screen.

Any help here?

[protonLeah]

To see the VBA Code, just right click any sheet tab and select View code from the pop-up menu. On the left side of the BV Editor window the Project explorer pane will show you a list of sheets and modules. Double click any sheet or module and the code, if any, will be put into the edit window.