Window Object Members

  • Article
Excel Developer Reference

Represents a window.

Methods

  Name Description
Bb225763.methods(en-us,office.12).gif Activate Brings the window to the front of the z-order.
Bb225763.methods(en-us,office.12).gif ActivateNext Activates the specified window and then sends it to the back of the window z-order.
Bb225763.methods(en-us,office.12).gif ActivatePrevious Activates the specified window and then activates the window at the back of the window z-order.
Bb225763.methods(en-us,office.12).gif Close Closes the object.
Bb225763.methods(en-us,office.12).gif LargeScroll Scrolls the contents of the window by pages.
Bb225763.methods(en-us,office.12).gif NewWindow Creates a new window or a copy of the specified window.
Bb225763.methods(en-us,office.12).gif PointsToScreenPixelsX Converts a horizontal measurement from points (document coordinates) to screen pixels (screen coordinates). Returns the converted measurement as a Long value.
Bb225763.methods(en-us,office.12).gif PointsToScreenPixelsY Converts a vertical measurement from points (document coordinates) to screen pixels (screen coordinates). Returns the converted measurement as a Long value.
Bb225763.methods(en-us,office.12).gif PrintOut Prints the object.
Bb225763.methods(en-us,office.12).gif PrintPreview Shows a preview of the object as it would look when printed.
Bb225763.methods(en-us,office.12).gif 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.
Bb225763.methods(en-us,office.12).gif 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).
Bb225763.methods(en-us,office.12).gif ScrollWorkbookTabs Scrolls through the workbook tabs at the bottom of the window. Doesn't affect the active sheet in the workbook.
Bb225763.methods(en-us,office.12).gif SmallScroll Scrolls the contents of the window by rows or columns.

Properties

  Name Description
Bb225763.properties(en-us,office.12).gif 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.
Bb225763.properties(en-us,office.12).gif 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.
Bb225763.properties(en-us,office.12).gif ActivePane Returns a Pane object that represents the active pane in the window. Read-only.
Bb225763.properties(en-us,office.12).gif 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.
Bb225763.properties(en-us,office.12).gif ActiveSheetView Read-only
Bb225763.properties(en-us,office.12).gif 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.
Bb225763.properties(en-us,office.12).gif AutoFilterDateGrouping Read/write
Bb225763.properties(en-us,office.12).gif Caption Returns or sets a Variant value that represents the name that appears in the title bar of the document window.
Bb225763.properties(en-us,office.12).gif DisplayFormulas Read/write
Bb225763.properties(en-us,office.12).gif DisplayGridlines Read/write
Bb225763.properties(en-us,office.12).gif DisplayHeadings Read/write
Bb225763.properties(en-us,office.12).gif DisplayHorizontalScrollBar True if the horizontal scroll bar is displayed. Read/write Boolean.
Bb225763.properties(en-us,office.12).gif DisplayOutline Read/write
Bb225763.properties(en-us,office.12).gif 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.
Bb225763.properties(en-us,office.12).gif DisplayRuler Read/write
Bb225763.properties(en-us,office.12).gif DisplayVerticalScrollBar True if the vertical scroll bar is displayed. Read/write Boolean.
Bb225763.properties(en-us,office.12).gif DisplayWhitespace Read/write
Bb225763.properties(en-us,office.12).gif DisplayWorkbookTabs True if the workbook tabs are displayed. Read/write Boolean.
Bb225763.properties(en-us,office.12).gif DisplayZeros Read/write
Bb225763.properties(en-us,office.12).gif EnableResize True if the window can be resized. Read/write Boolean.
Bb225763.properties(en-us,office.12).gif FreezePanes True if split panes are frozen. Read/write Boolean.
Bb225763.properties(en-us,office.12).gif GridlineColor Returns or sets the gridline color as an RGB value. Read/write Long.
Bb225763.properties(en-us,office.12).gif GridlineColorIndex Returns or sets the gridline color as an index into the current color palette or as the following XlColorIndex constant.
Bb225763.properties(en-us,office.12).gif Height Returns or sets a Double value that represents tThe height, in points, of the window.
Bb225763.properties(en-us,office.12).gif Index Returns a Long value that represents the index number of the object within the collection of similar objects.
Bb225763.properties(en-us,office.12).gif 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.
Bb225763.properties(en-us,office.12).gif OnWindow Returns or sets the name of the procedure that’s run whenever you activate a window. Read/write String.
Bb225763.properties(en-us,office.12).gif Panes Returns a Panes collection that represents all the panes in the specified window. Read-only.
Bb225763.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb225763.properties(en-us,office.12).gif 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.
Bb225763.properties(en-us,office.12).gif ScrollColumn Returns or sets the number of the leftmost column in the pane or window. Read/write Long.
Bb225763.properties(en-us,office.12).gif ScrollRow Returns or sets the number of the row that appears at the top of the pane or window. Read/write Long.
Bb225763.properties(en-us,office.12).gif SelectedSheets Returns a Sheets collection that represents all the selected sheets in the specified window. Read-only.
Bb225763.properties(en-us,office.12).gif Selection Returns the specified window, for a Windows object.
Bb225763.properties(en-us,office.12).gif SheetViews Read-only
Bb225763.properties(en-us,office.12).gif Split True if the window is split. Read/write Boolean.
Bb225763.properties(en-us,office.12).gif 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.
Bb225763.properties(en-us,office.12).gif SplitHorizontal Returns or sets the location of the horizontal window split, in points. Read/write Double.
Bb225763.properties(en-us,office.12).gif SplitRow Returns or sets the row number where the window is split into panes (the number of rows above the split). Read/write Long.
Bb225763.properties(en-us,office.12).gif SplitVertical Returns or sets the location of the vertical window split, in points. Read/write Double.
Bb225763.properties(en-us,office.12).gif 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.
Bb225763.properties(en-us,office.12).gif 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).
Bb225763.properties(en-us,office.12).gif Type Returns or sets a XlWindowType value that represents the window type.
Bb225763.properties(en-us,office.12).gif UsableHeight Returns the maximum height of the space that a window can occupy in the application window area, in points. Read-only Double.
Bb225763.properties(en-us,office.12).gif UsableWidth Returns the maximum width of the space that a window can occupy in the application window area, in points. Read-only Double.
Bb225763.properties(en-us,office.12).gif View Returns or sets the view showing in the window. Read/write XlWindowView.
Bb225763.properties(en-us,office.12).gif Visible Returns or sets a Boolean value that determines whether the object is visible. Read/write.
Bb225763.properties(en-us,office.12).gif 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.
Bb225763.properties(en-us,office.12).gif Width Returns or sets a Double value that represents the width, in points, of the window.
Bb225763.properties(en-us,office.12).gif 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.
Bb225763.properties(en-us,office.12).gif WindowState Returns or sets the state of the window. Read/write XlWindowState.
Bb225763.properties(en-us,office.12).gif 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).