Workbook.AfterSave Event (Excel)
Occurs after the workbook is saved.
Version Information
Version Added: Excel 2010
Syntax
expression .AfterSave(Success)
expression A variable that represents a Workbook object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
---|---|---|---|
Success |
Required |
Boolean |
Returns True if the save operation was successful; otherwise False. |
Return Value
Nothing
Example
The following code example displays a message box if the workbook was successfully saved.
Private Sub Workbook_AfterSave(ByVal Success As Boolean)
If Success Then
MsgBox ("The workbook was successfully saved.")
End If
End Sub