Autosave on Close

[Sundog]

Using Excel 2007, I have a file on a network server for trainees to sign up for classes. Sometimes a trainee will do all the necessary signup, then close Excel without saving; this loses all their changes. Is there a way to implement an Autosave on Close for this remote workbook?

[ABabeNChrist]

Just a thought, have you tried

Code: Select all

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    ThisWorkbook.Save
End Sub

[HansV]

In addition to ABabeNChrist's reply: the code he posted should go into the ThisWorkbook module of the workbook.
And it will work only if macros are enabled, of course.