Running a macro "On Save"

Hi,

Can anyone tell me how I can get a file to run a macro each time the file is saved. I know this is achievable but can't find how to do it.

Thanks in advance for any assistance.

Hello
Use this workbook event which fires before saving workbook :
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
If Not Cancel Then
'do your stuff here
End If
End Sub

To acces this event either right-click on the Excel icon immediately
situated left to th File Menu in Excel
or open VB Editor and double-click on Thisworkbook

HTH
Cordially
Pascal

"heski" <[email protected]> a écrit dans le
message de news: [email protected]...
>
> Hi,
>
> Can anyone tell me how I can get a file to run a macro each time the
> file is saved. I know this is achievable but can't find how to do it.
>
> Thanks in advance for any assistance.
>
>
> --
> heski
> ------------------------------------------------------------------------
> heski's Profile:
> http://www.excelforum.com/member.php...o&userid=30581
> View this thread: http://www.excelforum.com/showthread...hreadid=543201
>

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Application.Run "PutYourMacroNameHere"
End Sub

Vaya con Dios,
Chuck, CABGx3


"heski" wrote:

>
> Hi,
>
> Can anyone tell me how I can get a file to run a macro each time the
> file is saved. I know this is achievable but can't find how to do it.
>
> Thanks in advance for any assistance.
>
>
> --
> heski
> ------------------------------------------------------------------------
> heski's Profile: http://www.excelforum.com/member.php...o&userid=30581
> View this thread: http://www.excelforum.com/showthread...hreadid=543201
>
>