XL97: Page Setup Command Does Not Exist in Modules (163718)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q163718 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.
| Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
|---|
| Keywords: | kbprb kbProgramming KB163718 |
|---|
|