Microsoft
MicrosoftI like it!
Would it be possible to specify whether names are visible or hidden? FYI the AFE picks up hidden names from the workbook, and if you use it to change anything about them then they silently get converted to visible.
I would like to see support for worksheet-scoped names. Sometimes people go crazy with them, and you could make it considerably easier for us to review and maintain them.
It looks like the hidden metadata sheet would generally be bloat, and users who happen to unhide it would typically just see it as some cryptic thing. If there is a reason that users might want it past whatever is required for AFE to work behind the scenes, it seems like the kind of thing that would be appropriate to explicitly call when they want it (similar to the "Paste List" button from the "Paste Name" dialogue box).
When I use the AFE to create simple names that are just references to ranges (and sync), they don't appear in the dropdown of the name box, then name does not appear in the name box when the relevant range is selected, and they do not appear in the list of names within the "Go To" dialogue box. Everything else that I have looked at seems right (i.e. they do show in the name manager, their .Visible property is True, they can be referenced by other formulae, and typing them into the "Go To" dialogue box works). Saving the workbook, closing Excel then reopening does not make them appear in name box.
It would be nice if the comments the AFE editor and GitHub Gist could be tied to the comment field of the name manager (i.e. the .Comment property). Upon superficial inspection, it appears as though the comments in LAMBDA EXAMPLES.txt are structured in a way that lends itself to this.
