Worksheet.PrintPreview Method (Excel)

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

expression .PrintPreview(EnableChanges)

expression A variable that represents a Worksheet 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

Community Additions

ADD
Show:
© 2014 Microsoft