WindowState Property

Microsoft Excel Visual Basic

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