Option Buttons Help

[sAYk]

I hope I can explain my problem if you need further details please advise:

I have 6 Option Buttons (Form Control) on a worksheet, when I click
(Checked) any of them the rest automatically unchecked themselves, how can I
modify them, since I want to create two groups of 3 Option Button on each
group so if I click (checked) any of the Option Button in a group of 3 it
does not unchecked any of the Option Buttons on the other group of 3?

Thanks in Advance

Saul

 

[Dave Peterson]

Put each group into its own groupbox (also on that Forms toolbar).

 

[sAYk]

Thanks Dave, Your advise work well, but now how can I make the Groupbox
lines and Label invisible, I don't want it visible on the screen.

Saul

 

[Dave Peterson]

from a private email:

I don't think you can do this except via code.

Hit alt-f11 to get to the VBE
hit ctrl-G to see the immediate window

type this in and hit enter:

activesheet.groupboxes.visible = false

This hides all the groupboxes on the activesheet.