Disable Alert
If you want to save the workbook then put the following code:
ThisWorkbook.Save
If you don't want to save then put the following:
ThisWorkbook.Saved = True
--
A. Ch. Eirinberg
" wrote:
I've put this in my 'This Workbook' space. But it doesn't seem to be
working. Any ideas?
Private Sub Workbook_BeforeClose(Cancel As Boolean)
'Disables 'Do you want to save changes?' Alert Before Close
Application.DisplayAlerts = False
End Sub
|