Excel: Can't Set Page Orientation/Print Reduction Using Macro

• Microsoft Excel for the Macintosh, versions 1.x, 2.2, 3.0

SUMMARY

Microsoft Excel version 4.0 macros can access the page orientation option in the Page Setup dialog box. Using the reduction argument in the PAGE.SETUP command will adjust Excel's reduction option in the Page Setup dialog box.

Microsoft Excel versions 1.x through 3.0 macros cannot access the page orientation and percent-reduction options in the Page Setup dialog box in the File menu.

This limitation occurs because these options are set in the standard Page Setup dialog box, which varies from printer to printer. The Macintosh system software does not support the ability to change these items through a macro.

One possible solution is to use the PAGE.SETUP? command, which allows you to select orientation and reduction manually.

Another solution is to create a "template" document (for example, a worksheet or chart created before the macro was run). Instead of having the macro open a new worksheet or chart, the macro opens this template.