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 Last reviewed: September 12, 1996 |