On Wed, 12 Jun 2013 23:22:53 -0400, GS wrote:

Given the custom nature of the names feature, I'd be surprised if MS
provides much more than what we got with V12. I use JKP's NameManager
addin extensively and find it the best thing going for this.

As for what I think you're looking for...

I use VBA to setup local names based on a 'setup table' stored on a
hidden worksheet. This is described in the book entitled *Professional
Excel Development* in some detail. I use this to toggle the worksheet
UI settings between devmode and runmode mostly, but it serves to
populate sheets with defined names and set there runtime values at
design time as well.

The table basically lists sheet CodeNames in colA and the desired
DefinedNames as its headings.

The code cycles through the table checking each sheet for the existence
of the name, adds it if need be, and sets its value to what's stored in
the table.

Cool. Thanks. So it appears a recursive creation tool can be coded
rather easily. Thanks again.