Hello there, can you please tell me whats wrong with case VbNo?
its suposed to close the workboo when user select "No"
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = True
Application.DisplayAlerts = False
Dim exit1 As Integer
exit1 = MsgBox(" Would you like to save...