How to test for a workbook global name?

[rghpvf]

I need to test for a valid global name in a workbook, whether activated or not, before hyperlinking to it. Any ideas?

 

[Juan Pablo González]

What do you mean by "whether activated or not" ? and a global name, you refer to those things that you create under Insert | Names, Define ?

 

[rghpvf]

Yes, I mean those defined names. The file to be hyperlinked to may or may not be opened in the current Excel session.

 

[Juan Pablo González]

Well, still lost... maybe someone else knows what you mean ! sorry...