title: Run Worksheet Modules on Save
body: <p>I have a macro that is currently running within 4 worksheets that highlights cell rows within a certain range (the ranges differ for each worksheet) but to keep the worksheet looking clean and not to leave the highlighting it has built in to it a line that tells it to clear highlighting when I click cell A6 in each of the worksheets where the macro is contained. My issue is getting others who use the worksheet to follow this method, so I am trying to see if there is a way to use the Workbook_BeforeSave workbook function to clear all highlighting on the worksheets when the file is saved. </p>
  
  <p>Is there a way to iterate the "clear formatting" sub that exists in each worksheet from the Workbook module?  The clearing code in the worksheet modules is as follows (but I cannot seem to get it to function within the workbook module):</p>
  
  <pre><code>Dim bInRange As Boolean
  Static rOld As Range
  
  If Not bInRange Then
  Set rOld = Nothing
  Exit Sub
  End If
  </code></pre>