Microsoft Knowledge Base

Excel: Macro Doesn't Record Close or ESC with Print Report
Last reviewed: September 12, 1996
Article ID: Q101938
The information in this article applies to:
  • Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0
  • Microsoft Excel for the Macintosh, versions 4.0

The macro function REPORT.PRINT() has the same effect as choosing the Print Report command from the File menu. However, if you record a macro, choose Print Report from the File menu, and then choose the Close button or press the ESC key, Microsoft Excel does not record this function. Instead, the text string "Report Manager" appears in your macro. This behavior is unexpected.

When you choose the Close button in the Views dialog box, the following text string is recorded in the macro: 

   A2: Views Canceled
This behavior is similar to what you would expect the macro to do when you choose Close in the Print Report dialog box. However, the behavior described above occurs instead.

REFERENCES

"Function Reference," version 4.0, page 358

KBCategory: kbprint
KBSubcategory:

Additional reference words: 5.00 4.00 4.00a



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: September 12, 1996
©1997 Microsoft Corporation. All rights reserved. Legal Notices.