Group a range - closing the group does not hide the controls....

[rgablejr]

To hide Excel Form controls within a group range, you have to perform
the following steps:

a) Use the Select Objects arrow on the Drawing toolbar to select all
the form controls you want to hide.
b) From the Drawing toolbar, select Draw: Group.
c) Optional: If you require the flexibility to move the controls
around within the group range, with the objects still selected, choose
Draw: Ungroup.

When the group range is expanded/collapsed, the Form controls will
show/hide without loss of any functionality.


Have a great weekend,


Ray R. Gable, Jr.