XL97: Page Setup Command Does Not Exist in Modules

Last reviewed: February 12, 1998
Article ID: Q163718
The information in this article applies to:
  • Microsoft Excel 97 for Windows

SUMMARY

In Visual Basic for Applications in Microsoft Excel 97, the Page Setup command (on the File menu) is not available. However, in earlier versions of Microsoft Excel, the Page Setup command is available in a Visual Basic module. You can use this command to modify page settings, such as orientation, scaling, margins, headers, and footers.

MORE INFORMATION

Microsoft Excel 97 ignores Page Setup settings in a module that you create in an earlier version of Microsoft Excel. These settings are not retained if you save the workbook in the "Microsoft Excel Workbook" format. However, if you save the workbook in the "Microsoft Excel 5.0/95 Workbook" format, the settings are retained.

In Microsoft Excel 97, the Visual Basic Editor is the environment in which you create and edit Visual Basic code. The Visual Basic Editor uses an interface that is similar to Microsoft Visual Basic 4.0. This interface does not allow you to use Page Setup options.


Additional query words: 97 XL97 missing menu item
Keywords : xl97vbmigrate xlvbainfo kbprg
Version : WINDOWS:97
Platform : WINDOWS


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: February 12, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.