Microsoft Office Tutorials and References
In Depth Information
in Chapter 10, “Formatting Excel Objects,” but it makes sense to discuss how to change the
layout of your worksheets on the page by using the PageSetup property of the Wo rksheet object.
The PageSetup property of the Wo rksheet object actually returns a PageSetup object, which in
turn contains a series of properties reflecting the worksheet’s positioning, orientation,
margins, and level of detail when viewed. Table 7-6 lists a number of the more important
properties of the PageSetup object, but you can find a complete listing in the Visual Basic Editor
help system.
Table 7-6. Selected Properties of the PageSetup Object
Property
Description
BlackAndWhite
When set to True , forces a sheet to be printed in black and white.
BottomMargin
Determines the distance, in points, between the top of the footer
and the bottom of the worksheet.
CenterHorizontally
When set to True , centers the worksheet horizontally on the
printed page.
CenterVertically
When set to True , centers the worksheet vertically on the printed
page.
FirstPageNumber
Sets the page number assigned to the first printed page.
FitToPagesTall
Sets the number of vertical pages on which the worksheet will be
printed. Useful for shrinking a too-large worksheet onto a specific
number of pages.
FitToPagesWide
Sets the number of horizontal pages on which the worksheet will
be printed. Useful for shrinking a too-large worksheet onto a
specific number of pages.
FooterMargin
Determines the distance, in points, between the top of the footer
and the bottom of the printed page.
HeaderMargin
Determines the distance, in points, between the bottom of the
header and the top of the printed page.
LeftMargin
Determines the amount of white space to remain between the
edge of the page and the leftmost element of the worksheet.
Orientation
Determines whether a worksheet is in landscape mode
xlLandscape ) or portrait mode ( xlPortrait ). (
RightMargin
Determines the amount of white space to remain between the
edge of the page and the rightmost element of the worksheet.
TopMargin
Determines the amount of white space to remain between the
bottom of the header and the topmost element of the worksheet.
Zoom
Determines the magnification level of the worksheet view between
10 percent and 400 percent.
Search JabSto ::




Custom Search