title: Disable/Enable button in Excel/VBA
body: <p>I'm trying the following function in VBA/Excel:</p>
  
  <pre><code>Sub function_name()
    button.enabled=false
    Call Long_Function       ' duration: 10sec
    button.enabled=true
  End Sub
  </code></pre>
  
  <p>For some reason, this button disabling does not work (it stays enabled in the excel work sheet)
  I tried experimenting with DoEvents and delays, but no luck there.
  Any ideas?
  Thanks!</p>