Returns a Window object that represents the current window.
expression.ActiveWindow
expression Required. An expression that returns a Spreadsheet object.
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