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