Event change freeze my workbook
 

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

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

Event change freeze my workbook
 

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

Is it possible that you're creating an endless loop? Is the event
you're executing on the delete row itself? If so, then you're code
will keep executing on that event and cause a loop. To keep this from
happening create a global boolean variable like in the following pseudo
code;

DIM GTFVAR AS BOOLEAN

Sub ChangeEvent()

IF GTFVAR = FALSE THEN
GTFVAR = TRUE


'Make changes here


GTFVAR = FALSE

END IF

End Sub