BeforeClose Event Example
This example always saves the workbook if it's been changed.
Private Sub Workbook_BeforeClose(Cancel as Boolean) If Me.Saved = False Then Me.Save End Sub