Skip to main content

Application.WorkbookAfterSave event

Occurs after the workbook is saved.


expression.WorkbookAfterSave (WbSuccess)

expression A variable that represents an Application object.


Name Required/Optional Data type Description
Wb Required Workbook The workbook being saved.
Success Required Boolean Returns True if the save operation was successful; otherwise, False.

Return value



For information about how to use event procedures with the Application object, see Using events with the Application object.


The following code example displays a message box if the workbook was successfully saved. This code must be placed in a class module, and an instance of that class must be correctly initialized.

Private Sub App_WorkbookAfterSave(ByVal Wb As Workbook, ByVal Success As Boolean)
    If Success Then
        MsgBox ("The " & Wb.Name & " workbook was successfully saved.")
    End If
End Sub

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>