VBA - AfterSave event
 

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

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

VBA - AfterSave event
 

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


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"David Canal" wrote in message
nk.net...
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