Window.Zoom Property (Excel)
Returns or sets a Variant value that represents the display size of the window, as a percentage (100 equals normal size, 200 equals double size, and so on).
Syntax
expression .Zoom
expression A variable that represents a Window object.
Remarks
You can also set this property to True to make the window size fit the current selection.
This function affects only the sheet that's currently active in the window. To use this property on other sheets, you must first activate them.