title: VBA code doesn't run when cell is changed by a formula
body: <p><strong>Worksheet A</strong> has ranges of data that are collected from <strong>Worksheet B</strong>. <strong>Worksheet A</strong> has a macro that calculates if the data is above a value then calls an email module to email selected users.    </p>
  
  <p>When the data is manually input on <strong>Worksheet A</strong> the Macro works, however when data is pulled from <strong>Worksheet B</strong> it doesn't fire.</p>
  
  <p>I'm not sure what I need to change in my VBA code. </p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      Call MailAlert(Target, "B5:M5", 4) 
      Call MailAlert(Target, "B8:M8", 7) 
      Call MailAlert(Target, "B11:M11", 6)
      Call MailAlert(Target, "B14:M14", 2) 
      Call MailAlert(Target, "B17:M17", 4) 
      Call MailAlert(Target, "B20:M20", 1) 
      Call MailAlert(Target, "B23:M23", 3) 
      Call MailAlert(Target, "B26:M26", 1) 
      Call MailAlert(Target, "B29:M29", 5) 
      Call MailAlert(Target, "B32:M32", 1) 
      Call MailAlert(Target, "B35:M35", 7) 
      Call MailAlert(Target, "B38:M38", 20) 
      Call MailAlert(Target, "B41:M41", 0) 
  End Sub
  
  Private Sub MailAlert(ByVal Target As Range, ByVal Address As String, ByVal Value As Integer)
      If Target.Cells.Count &gt; 1 Then Exit Sub
      If Not Application.Intersect(Range(Address), Target) Is Nothing Then
          If IsNumeric(Target.Value) And Target.Value &gt; Value Then
          Call Mail_small_Text_Outlook
          End If
          Application.EnableEvents = True
      End If
  End Sub
  </code></pre>