MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Must Save warning


Posted by Mike on December 21, 2000 2:04 PM

I would either like the workbook to auto save when closing or place a Warning box/msg to prompt user to be sure they save befor they exit. Easy way out?
Thanks


Posted by greg on December 21, 2000 3:26 PM

response:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
ActiveWorkbook.Save

End Sub