in tools-macro-visual basic editor. navigate to 'Workbook' and then in the
dropdown select the 'before close' option and use the following

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

"pcor" wrote:

Excel has a command AUTO_OPEN
I would like to write a macro that will save the current workbook just
before it closes.
Where can I find all these nifty commands.Thanks