setting properties for shapes

[Hawk]

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

 

[Bob Phillips]

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]

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

 

[Bob Phillips]

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)