View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hawk Hawk is offline
external usenet poster
 
Posts: 23
Default setting properties for shapes

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