CODEWITHSUNDEEP
vbaexcel
Don Desrosiers
Don Desrosiers

Reputation: 143

Stop a 'worksheet_change' or worksheet_calculate from running

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"?

Upvotes: 1

Views: 2005

Answers (1)

Seb
Seb

Reputation: 1230

Yes, just set Application.EnableEvents to FALSE.

Don't forget to turn it ON back after your processing is completed.

Upvotes: 3

Related Questions