'Uncheck' option button on second click?

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.

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Sample workbook - hope this will suffice:

The code on the four option buttons should be self explanatory.
I am not sure whether you needed to select more than one in each column.
At the moment I have in 'Properties' set each option box to be grouped per column.
If you want each option to be selectable you will have to set each option button group to something unique.
The toggle on/off is activated by the 'mousedown_event' > over option button hold down left mouse button > move off option button and release left mouse button.
torachan.