WindowState Property

Microsoft Excel Visual Basic

WindowState Property

       

Returns or sets the state of the window. Read/write XlWindowState.

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