PrintPreview Method
TOC
Collapse the table of content
Expand the table of content

Workbook.PrintPreview Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Shows a preview of the object as it would look when printed.

expression .PrintPreview(EnableChanges)

expression A variable that represents a Workbook object.

Parameters

Name

Required/Optional

Data Type

Description

EnableChanges

Optional

Variant

Pass a Boolean value to specify if the user can change the margins and other page setup options available in print preview.

This example displays Sheet1 in print preview.

Worksheets("Sheet1").PrintPreview
Show:
© 2016 Microsoft