Stop the echo during macro operation


Posted by Dennis on February 06, 2001 12:19 PM

Access has a macro command called Echo that a person can turn off so that, during a series of macro steps, the results or steps will be surpressed. Does Excel have such a command?

I have a workbook I'm developing, that has a button on a splashpage. This button runs a series of macros that I've coded in VBA that goes out to external sources, refreshes the incoming data, and then refreshes a series of pivot tables and charts from the data.

The flicker you get as it runs each of these steps is rather annoying and it would be great if I could surpress it until it is finished.



Posted by Dave Hawley on February 06, 2001 12:33 PM


Hi Dennis

For Excel use:

Application.ScreenUpdating=False
<Your Code>
Application.ScreenUpdating=True

Dave
OzGrid Business Applications