ActiveWindow Property

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