title: Enable/disable Excel 2007 combobox
body: <p>I need to prohibit user from selecting value in  some Excel 2007 combobox control inserted via Developer menu by condition. Now I managed only to show/hide the control.</p>
  
  <pre><code>ActiveWorkbook.Worksheets("summary").Shapes("months").Visible = year &lt;&gt; ""
  </code></pre>
  
  <p>Is it possible to enable/disable it instead?</p>