View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Event sometimes stops firing?

Sounds like you disable events in your code and don't properly reenable
them. Perhaps if you posted the code, someone could give you a clue.

--
Regards,
Tom Ogilvy


"HotRod" wrote in message
...
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?