Application.WorkbookAfterRemoteChange Event (Excel)

Occurs after a remote user's edits to the workbook are merged.

Syntax

expression.WorkbookAfterRemoteChange(Wb)

expression A variable that represents an 'Application' object.

Parameters

Name Required or Optional Data Type Description
Wb Required Workbook The workbook which has been changed by a remote user.

Return value

Nothing

Example

This example shows you where you can place code that runs after merging an incoming remote change. This code must be placed in a class module and an instance of that class must be correctly initialized. For more information about how to use event procedures with the Application object, see Using Events with the Application Object.

Private Sub App_WorkbookAfterRemoteChange(ByVal Wb As Workbook)
    'A remote user has made a change to this workbook and that change has been merged.
    'The code in this subroutine will now be run.
End Sub

See also

AutoSave

Co authoring

Workbook Object