Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Setting the default properties for cells in all new spreadsheets | Excel Discussion (Misc queries) | |||
Setting custome RGB properties to specific cells | Excel Discussion (Misc queries) | |||
Setting format properties when opening Worksheet | Excel Worksheet Functions | |||
Setting properties for Embeded Excel in HTML | Excel Discussion (Misc queries) | |||
Setting Tab Properties in Excel | Excel Discussion (Misc queries) |