VBA - AfterSave event
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
--
Regards
Frank Kabel
Frankfurt, Germany
David Canal wrote:
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
|