WindowState Property [Excel 2003 VBA Language Reference]

  • Article

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

Applies to | Application Object | Window Object