You have to be careful, as workbook names are hidden from you if you have a
worksheet level name with the same name and that worksheet is active. See
http://www.xldynamic.com/source/xld.Names.html

--
HTH

Bob Phillips

"Paul Smith" wrote in message
...
I understand that if I call the workbook.names collection I am calling a
collection of all names that are present in the workbook.

What I want to be able to distinguish between which names are workbook
level
ones and which are worksheet level ones!

PWS