title: How do I disable and enable macros on the fly?
body: <p>I would like to test an Excel VBA app I made.<br>
  However the VBA code messes around with the visibility of cells and that's a pest when editing the sheet.  </p>
  
  <p>Is there an option is enable and disable macro's on the fly without having to</p>
  
  <pre><code>Close the sheet
  Change the macro settings
  Reopen the sheet
  Close the sheet
  Change the macro settings.
  etc.
  </code></pre>