Take a look he

http://www.mcgimpsey.com/excel/listnames.html

There's a link on that page to Jan Karel Pieterse's fabulous add-in
"Name Manger.xla"


In article ,
"pQp" wrote:

Thanks to all the folk who let us use their hard work for ourselves, I've
found a few great little addins that create a TOC with links for each page
by creating names in A1 of each page. (here's one if anybody wants something
like this http://www.tushar-mehta.com/excel/so...toccreator.zip)

But after lot of searching, I still can't find a way to do the same for
EVERY named range in a book.
If there's not one about that anyone knows of, could I create my own by
automating the making of links from a sheet of enumerated names somehow?
Or perhaps a click event which passes the name reference to a goto?
...or sumpthin!

Ta All