Ornery OptionButtons

[Bagharmin]

I have two very similar worksheets (out of several) in a very large workbook. On each of these two very similar worksheets are two option buttons (OptionButton1 and OptionButton2 on each sheet - ActiveX controls). I just realized today that, for some reason, my workbook is treating these two pairs of option buttons as if they were all on the same sheet - if I click one on one sheet, it clears the two on the other sheet.

In an effort to fix this, I deleted the two option buttons on one sheet and made two new ones - also called OptionButton1 and OptionButton2. However, I still have the same problem. These things are on two completely different (yet similarly named and set up) worksheets, but they act like they're all grouped together. Does anyone have any idea why?

Help.

 

[Bagharmin]

Never mind, folks. I finally found the GroupName property. All 4 option buttons were under the same GroupName, so I changed two of them.

Works fine now.