Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Application.DisplayAlerts = 0 ThisWorkbook.Save ThisWorkbook.Close Application.DisplayAlerts = 1 End Sub
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Application.DisplayAlerts = 0 ThisWorkbook.Save ThisWorkbook.Close Application.DisplayAlerts = 1 End Sub