Microsoft KB Archive/211917

= XL2000: Page Setup Command Does Not Exist in Modules =

Article ID: 211917

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211917





SUMMARY
In Visual Basic for Applications in Microsoft Excel 2000, the Page Setup command (on the File menu) is not available. However, in versions of Microsoft Excel earlier than Excel 97, 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 2000 ignores Page Setup settings in a module that you create in a version of Microsoft Excel earlier than Excel 97. 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 2000, 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: missing menu item XL2000

Keywords: kbhowto kbprogramming KB211917

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.