Stop Screen Flicker in Excel when Running Script

Have you ever writen or recorded a Macro for Excel but when you run the macro your screen flickers. An easy fix is to turn off the Screen Updating in your script.

Folow these steps in Excel;

1. Open Macro in Visual Basic Editor (Tools > Macros > Visual Basic Editor)
2. Double click on This Workbook on the Project Explorer
3. Find the start of your Macro and type Application.ScreenUpdating = False

This will stop the screen flickering when the Macro runs, this also has the added bonus of your macros running faster.

22 Square - IT Support Team