In the workbook's module BeforeClose even place a save command as illustrated
below:

================================================== ====
Private Sub Workbook_BeforeClose(Cancel As Boolean)

ActiveWorkbook.Save

End Sub
================================================== ====

--
Kevin Backmann


"mattsvai" wrote:


Is there any way to automatically save changes to an open excel sheet
using for example the beforeclose event trigger without prompting the
user?

Cheers


--
mattsvai
------------------------------------------------------------------------
mattsvai's Profile: http://www.excelforum.com/member.php...o&userid=31134
View this thread: http://www.excelforum.com/showthread...hreadid=512223