Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change event and calculate event | Excel Programming | |||
Change Workbook Event | Excel Programming | |||
Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming | |||
Chart Values that change based on Change event | Excel Programming | |||
change event/after update event?? | Excel Programming |