WindowState Property
Applies To
Application object, Window object.
Description
Returns or sets the state of the window. Can be one of the following XlWindowState constants: xlMaximized, xlMinimized, or xlNormal. Read/write Long.
Example
This example maximizes the application window in Microsoft Excel for Windows. (This property cannot be set on the Macintosh.)
Application.WindowState = xlMaximized
This example expands the active window to the maximum size available (assuming that the window isn't already maximized).
With ActiveWindow
.WindowState = xlNormal
.Top = 1
.Left = 1
.Height = Application.UsableHeight
.Width = Application.UsableWidth
End With