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

Thanks a pile


"Mike" wrote:

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

Workbook_Open() replaced AUTO_OPEN a few versions back. AUTO_OPEN is retained
for backward capability and eventually will no longer be recognized. Any code
utilizing AUTO_OPEN will no longer operate when that occurs!!!
Lou

"Mike" wrote:

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