Excel vba stop screen updating

That is to say, the status bar will continue to be updated even if you disable screen updating. Display Status Bar property to temporarily disable any status bar updates, further improving the performance of your macro.Let’s say you have a Worksheet_Change event implemented for Sheet1 of your workbook.

This flickering is Excel trying to redraw the screen in order to show the current state the worksheet is in.

Unfortunately, each time Excel redraws the screen, it takes up memory resources.

Simply set the Enable Events property False before running your macro.

Once you macro code is done running, you can set the Enable Events property back to True.

You can imagine how this behavior would slow down your macro.

Last modified 14-Nov-2016 21:45