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
|