Duke,

For Each WkBk in Workbooks
If WkBk.Windows(1).Visible Then
'- - - -
Next

Regards,
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Duke Carey"

wrote in message
...
I'd like to list all open - but NOT hidden - workbooks in a userform listbox.
However, I am unable to find any properties that tell if a book is hidden or
not.
You can try to activate each book and test for success, I suppose, but there
has to be a more elegant way than that. Isn't there?