Print named ranges and references

This gets you most of the way there...

Pick a clear are of a worksheet
Then...From the Excel Main Menu:
<insert><name><paste>....Click [Paste List]

That will create a 2-col list: Range Name, Refers_to

However, it will list ALL workbook-level names
and any sheet-level names for the current sheet.

It won't list sheet-level names for the other sheets.

Can you work with that?