Export (0) Print
Expand All
Expand Minimize

Application.WindowState Property

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

Syntax

expression.WindowState

expression   A variable that represents an Application object.

Example

This example maximizes the application window in Microsoft Excel.

Visual Basic for Applications
Application.WindowState = xlMaximized

This example expands the active window to the maximum size available (assuming that the window isn't already maximized).

Visual Basic for Applications
With ActiveWindow
    .WindowState = xlNormal
    .Top = 1
    .Left = 1
    .Height = Application.UsableHeight
    .Width = Application.UsableWidth
End With



Community Additions

ADD
Show:
© 2014 Microsoft