AutoSave before close

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

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