AutoSave before close

[mattsvai]

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

[Kevin B]

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
>
>

[mattsvai]

2 thumbs up! That's exactly what I wanted