View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default 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.