Is there a way to access names in Name Manager in another WB ?

[m5anon]

I had a very large WB that had grown out of control. The WB contained a few thousand lines of code.

I have since broken the WB into several smaller ones and created an add-in that gets opened when any one of these WBs is opened, allowing me to make code changes in just one place.

I do have one top-level WB that controls all the other WBs (maintains TOC, hyperlinks to open, status, etc).

Cells in the lower-level WB need constants which had been defined in the old WB Name Manager.

Apparently I cannot do that in Excel 2016. Scope is current limited to the current WB. Now my problem is that I do not want these re-defined them in every workbook.

Is there a way to define these constants in Name Manager or add them to my add-in but reference them in the lower-level WBs? Lower-level WBs knows about the top-level WB. I could have sworn older versions of Excel allowed names to be applied to all open WBs.

All suggestions and clever ideas welcome!
Thank you in advance.

 

[combo]

You can add names programmatically, example for workbook level name, constant in names layer, for current workbook:
[tt]ThisWorkbook.Names.Add Name:="const_PI", RefersTo:="=3.1415926535"[/tt]


combo