Name Manager for Excel
April 1, 2008 by Administrator · Leave a Comment
Name Manager, now at Version 4, is a Excel Add-In that I find useful. Many times I have had to deal with workbooks with more than 100 names, many that are no longer valid. Name Manager helps manage such a mess.
If you are in need of a utility to manage defined names in your workbooks, this one is a must-have. List all names in your active workbook. Filter them using 13 filters, e.g. “With external references”, “With errors”, Hidden, Visible. Show just names that contain a substring. Show just names unused in worksheet cells. Edit them in a simple dialog or make a list, edit the list and update all names in one go. Delete, hide, unhide selected names with a single mouse click.
Available free at http://www.jkp-ads.com/officemarketplacenm-en.asp
Available for 97, 2000, XP, and 2003. And now a version for 2007.
Update (March 2008): Name Manager and Name Manager 2007 is now at version 4.1 (Build 599). New features: 1) When detecting unused names, all objects are searched as well as your VBA project. 2) A tiny but extremely handy toolbar to the VBE has been added. Selecting a name will paste that name at the current insertion point in your code!
