HOWTO: How to prevent screen flicker during macros

Reference: Q0048

Article Last Modified on 15-Feb-2008

---

The information in this article applies to:

• XLL+ for Visual Studio .NET - 3, 4.1, 4.2, 4.3.1, 5.0
• XLL+ for Visual Studio 6 - 3, 4.1, 4.2, 4.3.1, 5.0
• XLL+ for Visual Studio 2005 - 5.0

---

How to prevent screen flicker during macros

Issue

I have a macro which makes a lot of changes to a workbook. How can I prevent the screen flickering while these changes are made?

Solution

To stop the flickering, you can stop the screen refreshing until you have finished updating cells:

CXlMacros::Echo(0);
// Update cells...
CXlMacros::Echo(1);

---

Copyright © Planatech Solutions Ltd 2002-2008. All trademarks are the properties of their respective owners.