Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. If you want to make sure that all changes are saved when the workbook closes
Private Sub Workbook_BeforeClose(Cancel As Boolean)
           If Not ThisWorkbook.Saved Then
           ThisWorkbook.Save
           End If
     End Sub