title: Excel VBA - Run macro before save
body: <p>I've been looking around on how to call my macro just before I save my document. I found this, but when I put my code inside it, it doesn't do anything. So I presume I'm missing something.</p>
  
  <pre><code>Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) 
  
  Set shtVO = Sheets("Voice orders")
  endRowVO = shtVO.Range("E" &amp; Rows.Count).End(xlUp).Row
  
  For Row = 11 To endRowVO
      If IsEmpty(shtVO.Cells(Row, 23).Value) = False Then
          If shtVO.Cells(Row, 3).Value &lt;&gt; shtVO.Cells(Row, 23) Then
              If shtVO.Cells(Row, 1).Value Like "*MIG*" Then
              Else
                  shtVO.Cells(Row, 1).Value = shtVO.Cells(Row, 1).Value + "MIG"
              End If
          End If
      End If
  Next Row
  
  End Sub 
  </code></pre>