PAGE.SETUP macro

Equivalent to clicking the Page Setup command on the File menu. Use PAGE.SETUP to control the printed appearance of your sheets.

There are three syntax forms of PAGE.SETUP. Syntax 1 applies if a sheet or macro sheet is active; syntax 2 applies if a chart is active; syntax three applies to Visual Basic modules and the info Window.

Arguments correspond to check boxes and text boxes in the Page Setup dialog box. Arguments that correspond to check boxes are logical values. If an argument is TRUE, Microsoft Excel selects the check box; if FALSE, Microsoft Excel clears the check box. Arguments for margins are always in inches, regardless of your country setting.

Syntax 1

Worksheets and macro sheets

PAGE.SETUP(head, foot, left, right, top, bot, hdng, grid, h_cntr, v_cntr, orient, paper_size, scale, pg_num, pg_order, bw_cells, quality, head_margin, foot_margin, notes, draft)

PAGE.SETUP?(head, foot, left, right, top, bot, hdng, grid, h_cntr, v_cntr, orient, paper_size, scale, pg_num, pg_order, bw_cells, quality, head_margin, foot_margin, notes, draft)

Syntax 2

Charts

PAGE.SETUP(head, foot, left, right, top, bot, size, h_cntr, v_cntr, orient, paper_size, scale, pg_num, bw_chart, quality, head_margin, foot_margin, draft)

PAGE.SETUP?(head, foot, left, right, top, bot, size, h_cntr, v_cntr, orient, paper_size, scale, pg_num, bw_chart, quality, head_margin, foot_margin, draft)

Syntax 3

Visual Basic Modules and the Info Window

PAGE.SETUP(head, foot, left, right, top, bot, orient, paper_size, scale, quality, head_margin, foot_margin, pg_num)

PAGE.SETUP?(head, foot, left, right, top, bot, orient, paper_size, scale, quality, head_margin, foot_margin, pg_num)

Head    specifies the text and formatting codes for the header for the current sheet . For information about formatting codes, see "Remarks" later in this topic.

Foot    specifies the text and formatting codes for the workbook footer.

Left    corresponds to the Left box and is a number specifying the left margin.

Right    corresponds to the Right box and is a number specifying the right margin.

Top    corresponds to the Top box and is a number specifying the top margin.

Bot    corresponds to the Bottom box and is a number specifying the bottom margin.

Hdng    corresponds to the Row & Column Headings check box. Hdng is available only in the sheet and macro sheet form of the function.

Grid    corresponds to the Cell Gridlines check box. Grid is available only in the sheet and macro sheet form of the function.

H_cntr    corresponds to the Center Horizontally check box in the Margins panel of the Page Setup dialog box.

V_cntr    corresponds to the Center Vertically check box in the Margins panel of the Page Setup dialog box.

Orient    determines the direction in which your workbook is printed.

Paper_size    is a number from 1 to 26 that specifies the size of the paper.

Scale    is a number representing the percentage to increase or decrease the size of the sheet. All scaling retains the aspect ratio of the original.

• To specify a percentage of reduction or enlargement, set scale to the percentage.

• For worksheets and macros, you can specify the number of pages that the printout should be scaled to fit. Set scale to a two-item horizontal array, with the first item equal to the width and the second item equal to the height. If no constraint is necessary in one direction, you can set the corresponding value to #N/A.

• Scale can also be a logical value. To fit the print area on a single page, set scale to TRUE.

Pg_num    specifies the number of the first page. If zero, sets first page to zero. If "Auto" is used, then the page numbering is set to automatic. If omitted, PAGE.SETUP retains the existing pg_num.

Pg_order    specifies whether pagination is left-to-right and then down, or top-to-bottom and then right.

Bw_cells    is a logical value that specifies whether to print cells and all graphic objects, such as text boxes and buttons, in color.

• If bw_cells is TRUE, Microsoft Excel prints cell text and borders in black and cell backgrounds in white.

• If bw_cells is FALSE , Microsoft Excel prints cell text, borders, and background patterns in color (or in gray scale).

Bw_chart    is a logical value that specifies whether to print chart in color.

Size    is a number corresponding to the options in the Chart Size box, and determines how you want the chart printed on the page within the margins. Size is available only in the chart form of the function.

Quality    specifies the print quality in dots-per-inch. To specify both horizontal and vertical print quality, use an array of two values.

Head_margin    is the placement, in inches, of the running head margin from the edge of the page.

Foot_margin    is the placement, in inches, of the running foot margin from the edge of the page.

Draft    corresponds to the Draft Quality checkbox in the Sheet tab and in the Chart tab of the Page Setup dialog box. If FALSE or omitted, graphics are printed with the sheet. If TRUE, no graphics are printed.

Notes    specifies whether to print cell notes with the sheet. If TRUE, both the sheet and the cell notes are printed. If FALSE or omitted, just the sheet is printed.

Remarks

Microsoft Excel no longer requires you to enter formatting codes to format headers and footers, but the codes are still supported and recorded by the macro recorder. You can include these codes as part of the head and foot text strings to align portions of the header or footer to the left, right, or center; to include the page number, date, time, or workbook name; and to print the header or footer in bold or italic.

Related Functions

DISPLAY   Controls screen and Info Window display

GET.DOCUMENT   Returns information about a workbook

PRINT   Prints the active workbook

WORKSPACE   Changes workspace settings

Return to index