XlWindowState can be one of these XlWindowState constants. |
xlMaximized |
xlNormal |
xlMinimized |
expression.WindowState
expression Required. An expression that returns one of the objects in the Applies To list.
Example
This example maximizes the application window in Microsoft Excel.
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