How to get ActiveWindow
I can only describe parentage of Excel's Windows as ambigous!
Assuming there is an active workbook, instead of ActiveWindow try -
Activeworkbook.windows(1)
which should return its expected parent.
Curiosity, why do you need to know its parent.
FWIW
b = ActiveWindow Is Nothing
is one way to determine there are no visible workbooks
Regards,
Peter T
wrote in message
oups.com...
What is the parent of ActiveWindow?
It's not available as ThisWorkbook.ActiveWindow or
Application.ActiveWindow .
Thanks.
|