Share via

ActiveWindow Property

  • Article

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.

Sub HideHeadings()
   Spreadsheet1.ActiveWindow.DisplayColumnHeadings = False
   Spreadsheet1.ActiveWindow.DisplayRowHeadings = False
End Sub

Applies to | Spreadsheet Object

See Also | Window Object