Screen updating

Excel & Word have the Screen Updating method thru which a developer can lock the main window from unnecessarily redrawing itself whilst the macro is being executed. If left alone, redrawing is not only ugly on the eyes it also takes more time for the macro to reach completion.

Hence I created this generic wrapper to lock the window updates.

screen updating-14

For a version of this tip written specifically for earlier versions of Excel, click here: Turning Off Screen Updating.

Many people write their own macros to manipulate the information in a workbook.

The idea is to use the first line near the beginning of your macro, and then use the second line near the end.

Thus, the main body of your macro can do its work behind the scenes without the necessity of stopping to update the screen.

Many times the macro may do quite a bit with the data, such as selecting different cells, replacing values or formulas, and taking other types of actions.

Last modified 25-May-2015 05:07