Run a macro upon saving
 

Probably a simple one - I am trying to set up a macro to run when the user
saves the file via the save icon. I have the macro set up to generate an
email with the file as an attachment, but would like the macro to run on
save. Thanks.

Run a macro upon saving
 

In Thisworkbook Module.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI _
As Boolean, Cancel As Boolean)
macroname or code to run
End Sub


Gord Dibben MS Excel MVP

On Wed, 12 May 2010 13:00:01 -0700, Donnette
wrote:

Probably a simple one - I am trying to set up a macro to run when the user
saves the file via the save icon. I have the macro set up to generate an
email with the file as an attachment, but would like the macro to run on
save. Thanks.