Define Named Range scope as "Workbook" instead of "Worksheet"

Hi!

I'm trying to create named ranges dynamically, and I found a way to make it work, but my problem is that it would create the named ranges with worksheet scope instead of global (workbook) scope. I need to refer to these ranges from other tabs, so it would be essential for me to solve this.

Here is my code:

Please Login or Register  to view this content.

How could I modify this to have the above ranges defined with global scope?
Thanks!

ActiveWorkbook.Names.Add ...