Application.ActiveWindow property

ExcelBaby May 9, 2022 1 minute to read

46 0

Table of contents

Returns a Window object that represents the active Excel window (the window on top). Returns Nothing if there are no windows open. Read-only.

Syntax

expression.ActiveWindow

expression A variable that represents an Application object.

This example displays the name (Caption property) of the active Excel window.

MsgBox "The name of the active window is " & ActiveWindow.Caption