This topic has not yet been rated - Rate this topic

Window Methods (Excel)

Office 2013

Published: July 16, 2012

This object has the following methods:

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.

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.