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.