No. The difference is that I'm using the forms buttons, not the control
buttons. I was able to do what you're describing with the control buttons.
I'll try to use the control buttons, although I'm not impressed with the look
of them. If anyone else knows anything about forms buttons then let me know.

"John Bundy" wrote:

Hmm, must be something different between 2002 and 2003. See if there is
anything in the properties when you select multiple values that says the
sheet name. That or I think i remember you might be able to give each in the
group the same name one at a time. Sorry not a 100% sure though.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Pete" wrote:

When I select all of the buttons in a row a go to the properties there is no
place to assign a group name. Could you explain this further?

"John Bundy" wrote:

Hold down CTL and click each option button in the first row, then go to
properties and in the group name box give them a name, do the same thing to
the ones in row 3 giving them the SAME group name. Select all in row 2 and
give them a seperate group name, and finally give group 4 a group name the
same as you did for row 2. Thats a mouthfull.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Pete" wrote:

I know how to use option buttons and group the option buttons in a group box.
I have a worksheet in which I the option button groups are separated from
each other. Example (the numbers represent the option button group):

Row 1: 1 1 1 1
Row 2: 2 2 2 2
Row 3: 1 1 1 1
Row 4: 2 2 2 2

If I overlap the group boxes than the option buttons do not stay separated.
If I create 4 groups then Row 1 will not deselect when Row 3 is selected.
Help!

I'm using 2002 Excel.