title: Run this Worksheet_Calculate when opening workbook without running my Macro
body: <p>Right now my process is working correctly, with the help of this community, however, I need this Worksheet_Calculate to NOT execute the Macro (<em>MacroRuns</em> for example) when the workbook opens, but I still need it to function the same way it is currently, after the workbook is opened.</p>
  
  <p>Thank you so much for your help in advance!</p>
  
  <h2>The Code I Am Using:</h2>
  
  <p><strong>in ThisWorkbook</strong></p>
  
  <pre><code>Option Explicit
  
  Private Sub Workbook_Open()
      TargetStart
  End Sub
  </code></pre>
  
  <p><strong>in the target sheet's code window</strong></p>
  
  <pre><code>Option Explicit
  
  Private Sub Worksheet_Calculate()
  Application.EnableEvents = False
      TargetCalc Me
  Application.EnableEvents = True
  End Sub
  </code></pre>
  
  <p><strong>in Module 1</strong></p>
  
  <pre><code>Option Explicit
  
  Public TargetValue As Variant
  Private Const cTarget As String = "C3"
  
  Sub TargetCalc(ws as Worksheet)
      If ws.Range(cTarget) &lt;&gt; TargetValue Then
  'this is where I would like the code to say something like, "if workbook just opened, exit -- otherwise continue. If this is even possible.
         Call MacroRuns
          TargetValue = ws.Range(cTarget).Value
      End If
  End Sub
  
  Sub TargetStart()
      TargetValue = Sheet1.Range(cTarget).Value
  End Sub
  
  
  Sub MacroRuns()
  
      Call UpdateMsgBox
  
  End Sub
  </code></pre>