I have a worksheet heavily laden with code. There are 'worksheet_change' and 'worksheet_calculate' functions amongst that code. during certain procedures this code runs unnecessarily sometimes when working on this sheet. Is there a line of code that would prevent running the 'worksheet_change' or worksheet_calculate macros? Kind of a "don't call"?
Yes, just set Application.EnableEvents to FALSE.
Don't forget to turn it ON back after your processing is completed.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments