Automatic Save on exit

[Ken_Gorham]

How do I ensure an automatic "Save" when exiting a workboo

 

[Earl Kiosterud]

Ken,

You get prompted for a save if there have been any changes. Otherwise,
it'll take a macro. It goes in the ThisWorkbook module. Paste it in from
here.

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