Excel: PAGE.SETUP Halts Macro with Show Info Window ActiveLast reviewed: November 16, 1994Article ID: Q80366 |
The information in this article applies to:
SUMMARYIf a Show Info window is active in Microsoft Excel, running a macro with the PAGE.SETUP function may result in a macro error if the function includes parameters for row and column headings and gridlines. (To access the Show Info window, choose Show Info from the Window menu.)
MORE INFORMATIONWith a Show Info window active, the File Page Setup command allows you to change the values in the Header and Footer text boxes and the Left, Right, Top, and Bottom Margins text boxes. Depending on the printer driver you're using, you may also be able to change the Orientation, Paper, and Scaling options. The Row & Column Headings and Gridlines check boxes are not present, and the Center Horizontally and Center Vertically check boxes are unavailable (dimmed). While there is no documented PAGE.SETUP function specifically for a Show Info window, including all of the 13 possible parameters will cause the macro to halt. The macro recorder will record the function with only 11 parameters, omitting the headings and gridlines because the appropriate options do not appear in the Page Setup dialog box. FALSE,FALSE will be recorded for H_Center and V_Center.
WorkaroundRemove the parameters in the PAGE.SETUP function for headings and gridlines.
Steps to Reproduce Problem
REFERENCES"Microsoft Excel Function Reference," version 3.0, pages 173-175
|
KBCategory: kbprint
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |