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...

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...

Thanks Bob...I was trying to use the shapes collection and
it causing me quite a bit of difficulty. Sometimes simple
solutions just pass right over my head. Thanks also for
the help with API stuff...

-----Original Message-----
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...


.

Your title was also mis-leading (presumably because of the approach you were
taking<vbg). Might have been why you didn't get an immediate response, it
certainly stopped me from looking.

Anyway, hope you are all sorted now.

--

HTH

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

"Hawk" wrote in message
...
Thanks Bob...I was trying to use the shapes collection and
it causing me quite a bit of difficulty. Sometimes simple
solutions just pass right over my head. Thanks also for
the help with API stuff...

-----Original Message-----
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...


.