How to stop Option Button unselecting one on different worksheet?
I have placed option buttons on multiple worksheets inside one workbook. I
need to be able to select an option button (setting its value to 'true') on
one worksheet then go to the other worksheet and make a selection there;
however, when I go to the second worksheet and make a selection it removes my
selection from the first worksheet (essentially making my selection for the
first sheet set to 'false'). How do I make the option buttons on each
worksheet work independently from the option buttons on other worksheets?
|