Rich wrote :


I therefore assume that I cannot handle events on that sheet.

I assumed... famous last words :)

You can set up an application level event handler in the addin..

in thisworkbook of the addin...
Option Explicit

Dim WithEvents appXL As Application

Private Sub appXL_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Debug.Print Target.Address(external:=True)
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Set appXL = Nothing
End Sub

Private Sub Workbook_Open()
Set appXL = Application
End Sub

now you'll see the address of ANY cell that is changed...

see the dropdowns in the codepane...
select appXL on the left..
check the available events on the right.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam