ExcelBanter - Suspend Execution

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Suspend Execution (https://www.excelbanter.com/excel-programming/336997-suspend-execution.html)

Kaval

Suspend Execution

I need to suspend execution of a worksheet change event while another
procedure is running.

Can somebody remind me of the code for this.

Thanks, Kaval

Norman Jones

Suspend Execution

Hi Kaval

Application.EnableEvents = False

Call OtherProcedure

Application.EnableEvents = True

---
Regards,
Norman

"Kaval" wrote in message
...
I need to suspend execution of a worksheet change event while another
procedure is running.

Can somebody remind me of the code for this.

Thanks, Kaval

All times are GMT +1. The time now is 07:36 PM.