Share via

PageSetup Object Members

  • Article
Excel Developer Reference

Represents the page setup description.

Properties

  Name Description
Bb242400.properties(en-us,office.12).gif AlignMarginsHeaderFooter Read/write
Bb242400.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Bb242400.properties(en-us,office.12).gif BlackAndWhite True if elements of the document will be printed in black and white. Read/write Boolean.
Bb242400.properties(en-us,office.12).gif BottomMargin Returns or sets the size of the bottom margin, in points. Read/write Double.
Bb242400.properties(en-us,office.12).gif CenterFooter Read/write
Bb242400.properties(en-us,office.12).gif CenterFooterPicture Returns a Graphic object that represents the picture for the center section of the footer. Used to set attributes about the picture.
Bb242400.properties(en-us,office.12).gif CenterHeader Read/write
Bb242400.properties(en-us,office.12).gif CenterHeaderPicture Returns a Graphic object that represents the picture for the center section of the header. Used to set attributes about the picture.
Bb242400.properties(en-us,office.12).gif CenterHorizontally True if the sheet is centered horizontally on the page when it's printed. Read/write Boolean.
Bb242400.properties(en-us,office.12).gif CenterVertically True if the sheet is centered vertically on the page when it's printed. Read/write Boolean.
Bb242400.properties(en-us,office.12).gif DifferentFirstPageHeaderFooter Read/write
Bb242400.properties(en-us,office.12).gif Draft True if the sheet will be printed without graphics. Read/write Boolean.
Bb242400.properties(en-us,office.12).gif EvenPage Read-only
Bb242400.properties(en-us,office.12).gif FirstPage Read-only
Bb242400.properties(en-us,office.12).gif FirstPageNumber Returns or sets the first page number that will be used when this sheet is printed. If xlAutomatic, Microsoft Excel chooses the first page number. The default is xlAutomatic. Read/write Long.
Bb242400.properties(en-us,office.12).gif FitToPagesTall Returns or sets the number of pages tall the worksheet will be scaled to when it's printed. Applies only to worksheets. Read/write Variant.
Bb242400.properties(en-us,office.12).gif FitToPagesWide Returns or sets the number of pages wide the worksheet will be scaled to when it's printed. Applies only to worksheets. Read/write Variant.
Bb242400.properties(en-us,office.12).gif FooterMargin Returns or sets the distance from the bottom of the page to the footer, in points. Read/write Double.
Bb242400.properties(en-us,office.12).gif HeaderMargin Returns or sets the distance from the top of the page to the header, in points. Read/write Double.
Bb242400.properties(en-us,office.12).gif LeftFooter Read/write
Bb242400.properties(en-us,office.12).gif LeftFooterPicture Returns a Graphic object that represents the picture for the left section of the footer. Used to set attributes about the picture.
Bb242400.properties(en-us,office.12).gif LeftHeader Read/write
Bb242400.properties(en-us,office.12).gif LeftHeaderPicture Returns a Graphic object that represents the picture for the left section of the header. Used to set attributes about the picture.
Bb242400.properties(en-us,office.12).gif LeftMargin Returns or sets the size of the left margin, in points. Read/write Double.
Bb242400.properties(en-us,office.12).gif OddAndEvenPagesHeaderFooter Read/write
Bb242400.properties(en-us,office.12).gif Order Returns or sets a XlOrder value that represents the order that Microsoft Excel uses to number pages when printing a large worksheet.
Bb242400.properties(en-us,office.12).gif Orientation Returns or sets a XlPageOrientation value that represents the portrait or landscape printing mode.
Bb242400.properties(en-us,office.12).gif Pages Read-only
Bb242400.properties(en-us,office.12).gif PaperSize Returns or sets the size of the paper. Read/write XlPaperSize.
Bb242400.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb242400.properties(en-us,office.12).gif PrintArea Returns or sets the range to be printed, as a string using A1-style references in the language of the macro. Read/write String.
Bb242400.properties(en-us,office.12).gif PrintComments Returns or sets the way comments are printed with the sheet. Read/write XlPrintLocation.
Bb242400.properties(en-us,office.12).gif PrintErrors Sets or returns an XlPrintErrors contstant specifying the type of print error displayed. This feature allows users to suppress the display of error values when printing a worksheet. Read/write .
Bb242400.properties(en-us,office.12).gif PrintGridlines True if cell gridlines are printed on the page. Applies only to worksheets. Read/write Boolean.
Bb242400.properties(en-us,office.12).gif PrintHeadings True if row and column headings are printed with this page. Applies only to worksheets. Read/write Boolean.
Bb242400.properties(en-us,office.12).gif PrintNotes True if cell notes are printed as end notes with the sheet. Applies only to worksheets. Read/write Boolean.
Bb242400.properties(en-us,office.12).gif PrintQuality Returns or sets the print quality. Read/write Variant.
Bb242400.properties(en-us,office.12).gif PrintTitleColumns Returns or sets the columns that contain the cells to be repeated on the left side of each page, as a string in A1-style notation in the language of the macro. Read/write String.
Bb242400.properties(en-us,office.12).gif PrintTitleRows Returns or sets the rows that contain the cells to be repeated at the top of each page, as a string in A1-style notation in the language of the macro. Read/write String.
Bb242400.properties(en-us,office.12).gif RightFooter Read/write
Bb242400.properties(en-us,office.12).gif RightFooterPicture Returns a Graphic object that represents the picture for the right section of the footer. Used to set attributes of the picture.
Bb242400.properties(en-us,office.12).gif RightHeader Returns or sets the right part of the header. Read/write String.
Bb242400.properties(en-us,office.12).gif RightHeaderPicture Read-only
Bb242400.properties(en-us,office.12).gif RightMargin Returns or sets the size of the right margin, in points. Read/write Double.
Bb242400.properties(en-us,office.12).gif ScaleWithDocHeaderFooter Read/write
Bb242400.properties(en-us,office.12).gif TopMargin Returns or sets the size of the top margin, in points. Read/write Double.
Bb242400.properties(en-us,office.12).gif Zoom Returns or sets a Variant value that represents a percentage (between 10 and 400 percent) by which Microsoft Excel will scale the worksheet for printing.