As a WAG in your code somewhere you are using

Application.EnableEvents = false

As a guess the corresponding

Application.EnableEvents = true

is missing or your sub exits/ends prior to running that line of code... The
other possibility is that you have generated an error which halts the code
prior to turning the events back on.

HTH


"HotRod" wrote:

I have code that is run when you do a cell change "Worksheet_Change"
normally everything seems to work fine but once and a while the code just
decides to stop firing. The only way to get it working again is to manually
fire the "Worksheet_Change" event. Any ideas?