Window.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 Window 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.

Return Value

Variant

This example displays Sheet1 in print preview.

Worksheets("Sheet1").PrintPreview

Concepts

Other resources

Show: