Window and Windows Members

The Window object and Windows collection have the following members . Key members (shown in bold) are covered in the following reference section:

1 Collection only

2 Object and collection

Activate

ActivateNext

ActivatePrevious

ActiveCell

ActiveChart

ActivePane

ActiveSheet

Application 2

Arrange 1

BreakSideBySide 1

Caption

Close

CompareSideBySideWith 1

Count 1

Creator 2

DisplayFormulas

DisplayGridlines

DisplayHeadings

DisplayHorizontalScrollBar

DisplayOutline

DisplayRightToLeft

DisplayVerticalScrollBar

DisplayWorkbookTabs

DisplayZeros

EnableResize

FreezePanes

GridlineColor

GridlineColorIndex

Height

Index

LargeScroll

Left

Panes

Parent 1

PointsToScreenPixelsX

PointsToScreenPixelsY

RangeFromPoint

RangeSelection

ResetPositionsSideBySide 1

ScrollColumn

ScrollIntoView

ScrollRow

ScrollWorkbookTabs

SelectedSheets

Selection

SmallScroll

Split

SplitColumn

SplitHorizontal

SplitRow

SplitVertical

SyncScrollingSideBySide 1

TabRatio

Top

Type

UsableHeight

UsableWidth

View

Visible

VisibleRange

Width

WindowNumber

WindowState

Zoom

  

Use the Windows collection and Window objects to control which window has focus in Excel and to open, close, arrange, and control the appearance of Excel windows. Use the Application object’s ActiveWindow ...

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial