Skip to content

Latest commit

 

History

History
49 lines (32 loc) · 996 Bytes

Excel.Window.WindowState.md

File metadata and controls

49 lines (32 loc) · 996 Bytes
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Window.WindowState property (Excel)
vbaxl10.chm356125
vbaxl10.chm356125
Excel.Window.WindowState
be51b777-1370-03a2-1e3b-a4a89205f6ca
05/21/2019
medium

Window.WindowState property (Excel)

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

Syntax

expression.WindowState

expression A variable that represents a Window object.

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 

[!includeSupport and feedback]