View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nesmith6866 nesmith6866 is offline
external usenet poster
 
Posts: 2
Default 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?