title: Excel VBA Option Buttons - how do you unselect them?
body: <p>I am trying to unselect <code>radio buttons</code> and I can't figure out how.
  My latest attempt looks like this:</p>
  
  <pre><code>Sheet1.Shapes("STCT" &amp; strNumbers).ControlFormat.Value = xlOff
  </code></pre>
  
  <p>Where the name of the <code>radio button</code> is <code>STCT04</code> (or 05, or 06, or... you get the pattern) and the number part of the name is stored in the string variable.
  I have also tried this</p>
  
  <pre><code>Sheet1.Shapes("STCT" &amp; strNumbers).Value = False
  </code></pre>
  
  <p>no luck. I've googled quite a bit, and in 95% of the cases the commenters suggest one of the two mentioned above, and the question poster always says it worked.
  It doesn't for me.</p>
  
  <p>What do I do then?</p>
  
  <p>Edit:
  I have a list of options to choose from, each has an assigned Button. I have some 10 options, but the user should sometimes only be able to chose from only 5 of those 10. (That's dependent on other things in my workbook.) In these cases (if an option doesn't apply) i'd like to set either the Button's "value" or "enabled" property to False.
  When I do that (change either one of the two properties), that unselects every previously existing selection as well. (As if the macro caller button was clicked.)
  I hope that makes sense.</p>
  
  <p>Ex: Let's say option 2 is selected. the decision's not final, but i have that selected. Then something changes and eliminates option 3 from the list of options. When I change one of Button3's two aforementioned properties, option 2 changes to unselected as well.</p>