Workbook_Activate not triggering

No, only if that window has focus. eg: if you had a browser open and your workbook is behind it.

Just try a test;

Private Sub Workbook_Activate()
    MsgBox "activated"
End Sub