title: Check if the month changes and reset the cells if the month has changed
body: <p>I am having the current date (TODAY()) in A4 cell. The format is Nov-15 and Values from B4:T4. I want to reset the values to 0 when the month changes from Nov to Dec. The following is my try,</p>
  
  <pre><code>Private Sub Workbook_Open()
      If Sheets("Output").Range("A4").Value Like "01*" Then Range("B4:T4").ClearContents
  End Sub
  </code></pre>
  
  <p>But my problem is, The sheet wont be opened every day. Suppose if the excel sheet is not opened on 1st, the values wont get reset. Can we modify this macro to run whenever the excel sheets open and check for the month on the previous run and if it has changed, we can reset the contents of the cell.</p>
  
  <p>Can anybody help me in doing this? </p>