Microsoft KB Archive/101938

= 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.