Hi,

I am having a bit of a hard time figuring out the best way to handle this problem. I have tried using both form control (no good as I need code to execute on click) and ActiveX checkboxes and option buttons to achieve my objective, which is this:

I have a sheet with a list of option buttons/checkboxes the user needs to click in order to show or hide the sheets they need. I have instances where multiple options are linked to a single sheet and need to be grouped so that only one option can be selected at a time, so I can't use checkboxes. However, I also need the user to be able to easily 'uncheck' an option button if they make a wrong selection. Ideally, by clicking the option button again, as you would with a checkbox. Is there a way to do this? I couldn't find anything in my extensive google searching.

NB: Even though the grouped options link to one sheet, I still need the user to make a distinct selection so that the linked cell can pass the details of the selection to the sheet.


To summarise, I need one of the following:

*ActiveX checkboxes that unhide a sheet when checked, and re-hide it when unchecked (I have this part working)
*a way to group some of the checkboxes so that only one selection can be made at a time

OR


*Form control checkboxes that unhide a sheet when checked, and re-hide it when unchecked


OR

*ActiveX option buttons that unhide a sheet when checked, and;
*a way to uncheck the option button with a click when a wrong selection is made

Whatever option is chosen, the buttons/checkboxes need to also link to a cell on the sheet.


I hope this makes sense, and as always, thanks in advance for any help and advice you can provide.