ActiveWindow Property

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Returns a Window object that represents the current window.

expression.ActiveWindow

expression   Required. An expression that returns a Spreadsheet object.

Example

This example hides the row and column headings in the active window of Spreadsheet1.

<pre IsFakePre="true" xmlns="http://www.w3.org/1999/xhtml">Sub HideHeadings() Spreadsheet1.<strong>ActiveWindow</strong>.DisplayColumnHeadings = False Spreadsheet1.<strong>ActiveWindow</strong>.DisplayRowHeadings = False End Sub</pre> ``