XL98: Page Setup Command Does Not Exist in Modules (181726)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q181726 SUMMARY
In the Visual Basic Editor in Microsoft Excel 98 Macintosh Edition, 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 98 Macintosh Edition ignores Page Setup settings in a
module that you created 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 98 Macintosh Edition, 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 for Windows. This interface does not allow you to use Page Setup
options.
Note that if you click Print on the File menu, and then click Setup, you
can change the paper size, orientation, and scaling. These changes are used
when you print a module.
| Modification Type: | Major | Last Reviewed: | 9/11/2002 |
|---|
| Keywords: | KB181726 |
|---|
|