• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

nagovind

Member
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

Excel Ninja
Staff member
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

Member
Hui


Thanks very much

sometimes some usual things are not clicking

thanks for your timely response; absence on mind

great !!
 

nagovind

Member
Hui


Thanks very much

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

thanks for your timely response

u r great !!
 
Top