Occurs before a remote user's edits to the workbook are merged.
Syntax
expression.WorkbookBeforeRemoteChange (Wb)
expression A variable that represents an Application object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Wb | Required | Workbook | The workbook that has been changed by a remote user. |
Return value
Nothing
Example
This example shows you where you can place code that runs before 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_WorkbookBeforeRemoteChange(ByVal Wb As Workbook)
'A remote user has made a change to this workbook.
'The code in this subroutine will be run before those changes are merged.
End Sub