View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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