You need to provide more details if you want constructive help.
What are supposed to make of "Doesn't work for me" ?

NickHK

"EricF" wrote in message
...
Doesn't work for me, at least not in Workbook_BeforeClose

"Corey" wrote:

Sub Macro1()
Application.DisplayAlerts = True
ActiveWorkbook.Save ' saves active workbook
Application.Quit ' exits Excel
End Sub


Corey....