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/Optional | Data type | Description |
---|---|---|---|
Wb | Required | Workbook | The workbook which has been changed by a remote user. |
Return value
Nothing
Remarks
For information about how to use event procedures with the Application object, see Using events with the Application object.
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.
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
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for