It should be quite simple

With ActiveSheet
.OptionButton1.GroupName = "Sheet1"
.OptionButton2.GroupName = "Sheet1"
.OptionButton3.GroupName = "Sheet1"
.OptionButton4.GroupName = "Sheet1"
End With


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Hawk" wrote in message
...
Excel 97...

I have 4 option-buttons on a worksheet. My code makes a
copy of the worksheet. Now I have 8 option-buttons (4 on
each worksheet). The 4 buttons on the new worksheet are
by default grouped with the 4 button on the old worksheet,
but I would like each worksheet's set of 4 to be grouped
only with each-other (NOT all 8). Can I change the
GroupName property for the option-buttons via code?

Note that I added the 4 option buttons from the Control
Toolbox Toolbar.

If I add the option-buttons from the Forms Toolbar the
buttons seem to be grouped based on the worksheet. This
appears to be a solution, but I would like to know if
there is a way to make it work with the option-buttons
from the Control Toolbox.

I have noticed in the past that strange things haapen when
I put Option-Buttons or Checkboxes directly on a
worksheet. Sometimes when I print from different
printers, they seem to move around. Does anyone have any
input on this?

TIA...