Enable a macro AFTER completly saving a file using save as function

[nagovind]

Dear All !!


Is it Possible to Run a macro


after saving a excel file using save as function with new file name ?


In otherwords "code" should run automatically AFTER 100% completion of save operation using save as function


Please help

 

[Hui]

Nagovind

Excel has two events in VBA which revolve around Saving

The names tell which is which


Sub Workbook_AfterSave(ByVal Success As Boolean)

&

Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)


ByVal in the AfterSave event allows for you to check that the save was successful and adjust your code if it wasn't

 

[nagovind]

Hui


Thanks very much

sometimes some usual things are not clicking

thanks for your timely response; absence on mind

great !!

 

[nagovind]

Hui


Thanks very much

sometimes some usual things are not clicking ; for me absence on mind

thanks for your timely response

u r great !!