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).
expression A variable that represents a Window object.
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.