Did you play with the file sent, is it working?
With your file
Before all treatments launch next macro to enable event
Macro to be put in a module
Sub ttt
        Application.EnableEvents = True
End Sub