I'm going to bullet point this to hopefully make what I need simpler.

. I need a code that resets an option button so that if its clicked AGAIN it goes back to unticked like a tick box would.
. reason being
- if users accidentally click on one it is conditionally formatted to colour certain cells etc and at present there is no way for them to cancel - undo this action.
. i tried to macro/button a solution so it would reset AND this would work easily BUT i have MANY grouped option buttons so i really don't want to create a button a couple hundred times.
. is there anyway i can code it so that if the option button is clicked once its "ticked" that it resets to "unticked"? like a tick box would - but with an option button??


i would do this myself but i know how to code tick boxes through the activesheet.shapes thing but that doesn't work with option buttons because i guess they are form controls