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. |
All times are GMT +1. The time now is 07:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com