Excel: ECHO() Command Doesn't Suppress Menu Bar Updating

Last reviewed: July 16, 1997
Article ID: Q84655

The information in this article applies to:

- Microsoft Excel for Windows, versions 2.x, 3.0, and 4.0

SUMMARY

In Microsoft Excel, the ECHO() command is used to suppress screen updates while a macro is running. If an ACTIVATE() command is used to switch between a worksheet and a chart while ECHO() is set to false, the menu bar will update although you will not see the newly activated file.

MORE INFORMATION

The ECHO() command prevents a redraw of the main Microsoft Excel window's client area. The client area of a window is the area of the window that does not include the area of the borders, title bar, and menu bar. As a result, the ECHO() command will have no effect on the updating of the menu bar.

REFERENCES

"Microsoft Excel Function Reference," version 4.0, page 122 "Microsoft Excel Function Reference" for Windows, version 3.0, page 62

Additional query words: 2.00 2.10 3.00 4.00 echo screen updating
menu bar

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: July 16, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.