Export (0) Print
Expand All
Expand Minimize

Workbook.AfterSave Event (Excel)

Occurs after the workbook is saved.

Version Added: Excel 2010

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

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
Show:
© 2015 Microsoft