Export (0) Print
Expand All

Sheets.PrintPreview Method

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

Syntax

expression.PrintPreview(EnableChanges)

expression   A variable that represents a Sheets object.

Parameters

NameRequired/OptionalData TypeDescription
EnableChangesOptionalVariantPass 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.

Visual Basic for Applications
Worksheets("Sheet1").PrintPreview



Community Additions

ADD
Show:
© 2014 Microsoft