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

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

2 thumbs up! That's exactly what I wanted :

--
mattsva
-----------------------------------------------------------------------
mattsvai's Profile: http://www.excelforum.com/member.php...fo&userid=3113
View this thread: http://www.excelforum.com/showthread.php?threadid=51222