Hi,
If the code failed you may need to "Reset" it. The problem with worksheet function is there are a pain to use.
In the same module try this code to reset the worksheet event.
Code:
Sub Reset_worksheet
Application.EnableEvents = True
end sub
Then run it. Then try your worksheet code.