WindowState Property

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