Excel - How do I set up a file to automatically save on exit?

Asked By Brian on 15-May-10 05:57 AM
I have created a file that several users will be accessing with varying
computer skill level.  I want to be sure that the file saves automatically
when they close the file out rather than having to answer "yes" to the "Do
you want to save this file?" question.  Can this be done?

Otto Moehrbach replied to Brian on 15-May-10 11:34 AM
Yes, that can be done with VBA programming.  The following macro will
save the file whenever a close command is issued by the user, regardless of
whether the file has already been saved.  This is a Workbook event macro and
must be placed in the workbook module.  Post back and provide your Excel
version if you need more help with this..  HTH  Otto
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayAlerts = False
ThisWorkbook.Saved = True
Application.DisplayAlerts = True
End Sub