Prev: Call List Macro
Next: Pull out lastname
From: Donnette on 12 May 2010 16:00
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.
From: Gord Dibben on 12 May 2010 17:02
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
<Donnette(a)discussions.microsoft.com> 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.

 | 
Pages: 1
Prev: Call List Macro
Next: Pull out lastname