Application.ActiveWindow property (Excel)
Returns a Window object that represents the active Excel window (the window on top). Returns Nothing if there are no windows open. Read-only.
expression.ActiveWindow
expression A variable that represents an Application object.
This example displays the name (Caption property) of the active Excel window.
VB
MsgBox "The name of the active window is " & ActiveWindow.Caption
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.