You have to group them by putting each set in a group box from the forms
toolbar.

--
Biff
Microsoft Excel MVP


"John Calder" wrote in message
...
Hi

I run Excel 2000

I have 2 option buttons in each row (total of 20 rows)


I would like the only one of the 2 buttons in each row are on or off.

The problem I am having is that it dosent matter which button on which row
I
select, only that button is active. All the other buttons go blank.

I have tried changing the source for each pair of buttons but when I do
all
the other button sources change as well.

How do i set up the buttons so that I can select one of the 2 in every
row.?

Example

20 buttons in total - 10 buttons active and 10 buttons inactive


Thanks


John