Workbook.PrintPreview Method (Excel)

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

Syntax

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.

Example

This example displays Sheet1 in print preview.

Worksheets("Sheet1").PrintPreview

See Also

Concepts

Workbook Object

Workbook Object Members