Application screenupdating does not work
I’m currently on a project to improve the performance of a particular workbook.
Part of this task involves speeding up a few of the macros in the workbook.
This saves time and resources, allowing your macro to run a little faster.
Once you macro code is done running, you can turn screen updating back on.
Be sure to think about our specific scenario and determine what will happen if your worksheet or workbook events are turned off while your macro runs.