View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] rgablejr@gmail.com is offline
external usenet poster
 
Posts: 4
Default Group a range - closing the group does not hide the controls....

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.