Skip to content

Latest commit

 

History

History
49 lines (32 loc) · 1.01 KB

Excel.Application.WindowState.md

File metadata and controls

49 lines (32 loc) · 1.01 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Application.WindowState property (Excel)
vbaxl10.chm133234
vbaxl10.chm133234
Excel.Application.WindowState
f53d2bb8-b862-c55f-d9d5-68e705ca3415
04/05/2019
medium

Application.WindowState property (Excel)

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.

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]