They is no way through the UI to do this so you must use a macro. This
hides all of them on the active worksheet:
Sub HideGBs()
Activesheet.Groupboxes.Visible = False
End Sub
--
Jim
"Julian" wrote in message
...
| How would I go about hiding these group boxes?
|
| "Jim Rech" wrote:
|
| If you're using option buttons from the Forms toolbar put a group box
around
| the ones your want to operate together. You can make the group boxes
hidden
| and this will still work. The option buttons must be entirely inside
the
| group box.
|
| If you're using option buttons from the Control Toolbox just give the
ones
| in sync the same Groupname (in their Properties).
|
| --
| Jim
| "Julian" wrote in message
| ...
| | I'm trying to make a table that has 4 rows of 3 option buttons within
it.
| | The tricky part is that I want each row of option buttons to act
| | independently of the other rows.
| |
| | I can't seem to be able to find a way to do this, because no matter
what
| | cell I link any of the buttons to they all just follow suit, so i end
up
| with
| | 12 buttons linked to one cell every time.
| |
| | I'm using MS Excel 2003 if that makes a difference. Thanks in advance
for
| | any help anyone can provide.
|
|
|
|