Applies To
PageSetup Object, Window Object.
Description
PageSetup object:
Returns or sets a percentage to scale the worksheet for printing, between 10 and 400 percent. Read-write.
If this property is False, the FitToPagesWide and FitToPagesTall properties control how the worksheet is scaled.
Window object:
Returns or sets the display size of the window, in percent (100 means show at normal size; 200 means the window is double size, etc.).
The property can also be set to True to set the window size to fit the current selection.
Remarks
PageSetup object:
This property applies only to worksheets.
All scaling retains the aspect ratio of the original document.
Window object:
This function will only affect the sheet that is currently active in the window. To use this property on other sheets, you must first activate them.
Example
This example scales Sheet1 by 150 percent when the worksheet is printed.
Worksheets("Sheet1").PageSetup.Zoom = 150