VBA - AfterSave event

[David Canal]

Is there an AfterSave event? I want to include a set of VBA code to be
executed automatically every time after the workbook is saved. I have some
experience programming in VBA for Excel, I found a BeforeSave event, but not
an AfterSave, how could I create it? Thanks, Alfredo

 

[Frank Kabel]

Hi David
there's no AfterSave event but you could use the Before_Save event. Try
for example:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
application.enableevents=false
me.save
application.enableevents=True
'now your code for the after save part

Cancel=True
End Sub

 

[Rob van Gelder]

I have an AfterSave example on my website. It can handle Save As...
It's in the section: Save Changes?