title: Is there a Macro to hide all sheets in a workbook when a certain cell is equal to 100%?
body: <p>I understand the logic behind this but I'm unsure how to right the macro. I import up to 63 sheets of data into excel.</p>
  
  <p>ALL of the sheets have a status in Column B Row 9. I would like to make a macro to hide all sheets in the workbook when B9 = 100%</p>
  
  <pre><code>If Worksheet.Column.B, Row.9= 100%
  Worksheet.hide
  </code></pre>