View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_2_] Patrick Molloy[_2_] is offline
external usenet poster
 
Posts: 1,298
Default Event change freeze my workbook

please show the code.
Note that deleting a row fires the event. If you delete by using code, then
precede the delete routine with
Application.EnableEvents = False
to turn OFF events
after the deletion code , turn events on with
Application.EnableEvents = True


"broogle" wrote:

Hi,

I have an event change sheet on my workbook, everytime I delete row(s)
my excel is freezing. I have to force to close the whole excel. Any
idea?
Thanks