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
Wednesday 4 November 2009
Subscribe to:
Posts (Atom)