Window Members (Excel)

Represents a window.

Name

Description

Activate

Brings the window to the front of the z-order.

ActivateNext

Activates the specified window and then sends it to the back of the window z-order.

ActivatePrevious

Activates the specified window and then activates the window at the back of the window z-order.

Close

Closes the object.

LargeScroll

Scrolls the contents of the window by pages.

NewWindow

Creates a new window or a copy of the specified window.

PointsToScreenPixelsX

Converts a horizontal measurement from points (document coordinates) to screen pixels (screen coordinates). Returns the converted measurement as a Long value.

PointsToScreenPixelsY

Converts a vertical measurement from points (document coordinates) to screen pixels (screen coordinates). Returns the converted measurement as a Long value.

PrintOut

Prints the object.

PrintPreview

Shows a preview of the object as it would look when printed.

RangeFromPoint

Returns the Shape or Range object that is positioned at the specified pair of screen coordinates. If there isn’t a shape located at the specified coordinates, this method returns Nothing.

ScrollIntoView

Scrolls the document window so that the contents of a specified rectangular area are displayed in either the upper-left or lower-right corner of the document window or pane (depending on the value of the Start argument).

ScrollWorkbookTabs

Scrolls through the workbook tabs at the bottom of the window. Doesn't affect the active sheet in the workbook.

SmallScroll

Scrolls the contents of the window by rows or columns.

Name

Description

ActiveCell

Returns a Range object that represents the active cell in the active window (the window on top) or in the specified window. If the window isn't displaying a worksheet, this property fails. Read-only.

ActiveChart

Returns a Chart object that represents the active chart (either an embedded chart or a chart sheet). An embedded chart is considered active when it's either selected or activated. When no chart is active, this property returns Nothing.

ActivePane

Returns a Pane object that represents the active pane in the window. Read-only.

ActiveSheet

Returns an object that represents the active sheet (the sheet on top) in the active workbook or in the specified window or workbook. Returns Nothing if no sheet is active.

ActiveSheetView

Returns an object that represents the view of the active sheet in the specified window. Read-only.

Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.

AutoFilterDateGrouping

True if the auto filter for date grouping is currently displayed in the specified window. Read/write Boolean.

Caption

Returns or sets a Variant value that represents the name that appears in the title bar of the document window.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

DisplayFormulas

True if the window is displaying formulas; False if the window is displaying values. Read/write Boolean.

DisplayGridlines

True if gridlines are displayed. Read/write Boolean.

DisplayHeadings

True if both row and column headings are displayed; False if no headings are displayed. Read/write Boolean.

DisplayHorizontalScrollBar

True if the horizontal scroll bar is displayed. Read/write Boolean.

DisplayOutline

True if outline symbols are displayed. Read/write Boolean.

DisplayRightToLeft

True if the specified window is displayed from right to left instead of from left to right. False if the object is displayed from left to right. Read-only Boolean.

DisplayRuler

True if a ruler is displayed for the specified window. Read/write Boolean.

DisplayVerticalScrollBar

True if the vertical scroll bar is displayed. Read/write Boolean.

DisplayWhitespace

True if whitespace is displayed. Read/write Boolean.

DisplayWorkbookTabs

True if the workbook tabs are displayed. Read/write Boolean.

DisplayZeros

True if zero values are displayed. Read/write Boolean.

EnableResize

True if the window can be resized. Read/write Boolean.

FreezePanes

True if split panes are frozen. Read/write Boolean.

GridlineColor

Returns or sets the gridline color as an RGB value. Read/write Long.

GridlineColorIndex

Returns or sets the gridline color as an index into the current color palette or as the following XlColorIndex constant.

Height

Returns or sets a Double value that represents tThe height, in points, of the window.

Hwnd

Index

Returns a Long value that represents the index number of the object within the collection of similar objects.

Left

Returns or sets a Double value that represents the distance, in points, from the left edge of the client area to the left edge of the window.

OnWindow

Returns or sets the name of the procedure that’s run whenever you activate a window. Read/write String.

Panes

Returns a Panes collection that represents all the panes in the specified window. Read-only.

Parent

Returns the parent object for the specified object. Read-only.

RangeSelection

Returns a Range object that represents the selected cells on the worksheet in the specified window even if a graphic object is active or selected on the worksheet. Read-only.

ScrollColumn

Returns or sets the number of the leftmost column in the pane or window. Read/write Long.

ScrollRow

Returns or sets the number of the row that appears at the top of the pane or window. Read/write Long.

SelectedSheets

Returns a Sheets collection that represents all the selected sheets in the specified window. Read-only.

Selection

Returns the specified window, for a Windows object.

SheetViews

Returns the SheetViews object for the specified window. Read-only.

Split

True if the window is split. Read/write Boolean.

SplitColumn

Returns or sets the column number where the window is split into panes (the number of columns to the left of the split line). Read/write Long.

SplitHorizontal

Returns or sets the location of the horizontal window split, in points. Read/write Double.

SplitRow

Returns or sets the row number where the window is split into panes (the number of rows above the split). Read/write Long.

SplitVertical

Returns or sets the location of the vertical window split, in points. Read/write Double.

TabRatio

Returns or sets the ratio of the width of the workbook's tab area to the width of the window's horizontal scroll bar (as a number between 0 (zero) and 1; the default value is 0.6). Read/write Double.

Top

Returns or sets a Double value that represents the distance, in points, from the top edge of the window to the top edge of the usable area (below the menus, any toolbars docked at the top, and the formula bar).

Type

Returns or sets a XlWindowType value that represents the window type.

UsableHeight

Returns the maximum height of the space that a window can occupy in the application window area, in points. Read-only Double.

UsableWidth

Returns the maximum width of the space that a window can occupy in the application window area, in points. Read-only Double.

View

Returns or sets the view showing in the window. Read/write XlWindowView.

Visible

Returns or sets a Boolean value that determines whether the object is visible. Read/write.

VisibleRange

Returns a Range object that represents the range of cells that are visible in the window or pane. If a column or row is partially visible, it's included in the range. Read-only.

Width

Returns or sets a Double value that represents the width, in points, of the window.

WindowNumber

Returns the window number. For example, a window named "Book1.xls:2" has 2 as its window number. Most windows have the window number 1. Read-only Long.

WindowState

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

Zoom

Returns or sets a Variant value that represents the display size of the window, as a percentage (100 equals normal size, 200 equals double size, and so on).

Show:
© 2014 Microsoft