Initiate Macro On Save

[JTWood]

I need to initiate a macro when someone tries to "save" or "save as...
a file. Is that possible

 

[Guest]

There is a Before Save Event associted with ThisWorkbook. Right Click the
Excel Icon next to File on the menu bar and select View Code. Then paste the
following...

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
msgbox "you are saving..."
End Sub

 

[JTWood]

There is a Before Save Event associted with ThisWorkbook. Right Clic
the
Excel Icon next to File on the menu bar and select View Code. The
paste the
following...

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel A
Boolean)
msgbox "you are saving..."
End Sub

Excellent. I will try this out today.

Thanks