Hello,
I am having issues getting the BeforeRemoteChange event to trigger properly. I can not get either the before or after events to trigger. I have the following code that i know partially works, because it is triggered for sheet changes events. This tells me my app is setup properly, but i get nothing when others make changes to the worksheet remotely. Any ideas?
I am having issues getting the BeforeRemoteChange event to trigger properly. I can not get either the before or after events to trigger. I have the following code that i know partially works, because it is triggered for sheet changes events. This tells me my app is setup properly, but i get nothing when others make changes to the worksheet remotely. Any ideas?
VBA Code:
Option Explicit
Public WithEvents App As Application
Private Sub Workbook_Open()
Set App = Application
End Sub
Private Sub App_WorkbookBeforeRemoteChange(ByVal Wb As Workbook)
MsgBox Wb.Name & " is being remotely changed"
End Sub
Private Sub App_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Debug.Print "local change detected"
End Sub
Private Sub App_WorkbookAfterRemoteChange(ByVal Wb As Workbook)
Debug.Print "After change detected"
End Sub