MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to "freeze" the display while a macro is running


Posted by mabaud on June 06, 2001 4:03 AM

Could someone please explain me how to "freeze" the display while a macro is running.
thanks
mabaud


Posted by JAF on June 06, 2001 4:12 AM

Not quite sure if this is what you mean, but to stop the screen from "flickering" when running a macro, include the following line:
Application.ScreenUpdating = False

This not only preserves your eyesight (and sanity) when running macros that move about and between worksheets, but also makes the macro run faster as well.