Collapsing/Hiding radio and macro buttons

[Lance Gray]

We are trying to create a form that will allow users to enter data, but due
to the size of our worksheet, we want to collapse rows to reduce space.
Using the forms toolbar, we are creating selection options using radio
buttons, etc, but when we collapse the columns, the button do not go away.
Under "Format Contro - Properties", we can't set up the controls to collapse
as required. Any suggestions?
Thank You
Lance

 

[Dave Peterson]

The controls from the Control toolbox toolbar have that option.

 

[Lance Gray]

Thank you Dave. The only problem with the Control Box tools, is that we
cannot seem to group the radio buttons together. All of them operate
together, whether you want them to or not. If we go into Properties, the
only thing that looks like we can do is turn the Triple State to True ( so
that you can have more than one button selected at a time).
Thanks
Lance

 

[Dave Peterson]

If you used the optionbuttons from the Forms toolbar, then draw a GroupBox
around each pair of optionbuttons. (The groupbox is also on the Forms toolbar.)

If you used optionbuttons from the Control toolbox toolbar, then right click on
each and change the groupname. Use a unique groupname for each group of
optionbuttons.

(The default groupname is the sheet name--that's why they're all grouped
together.)

Thank you Dave. The only problem with the Control Box tools, is that we
cannot seem to group the radio buttons together. All of them operate
together, whether you want them to or not. If we go into Properties, the
only thing that looks like we can do is turn the Triple State to True ( so
that you can have more than one button selected at a time).
Thanks
Lance