Name Manager: Range names made easy

For Microsoft^® Excel^®

Description

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.

Created in collaboration with Charles Williams, www.decisionmodels.com and Matthew Henson (mhenson@mac.com) who ensured the utility works on Mac Excel too. See a screenshot here.

The Name Manager is freeware, all I'd like to ask you is to tell everyone if you like it and to tell me if you don't.

Current version downloads

Name Manager for Excel 2000, XP and 2003 v4.1 (Build 606 ,Updated 22 Feb 2009, 736k, Downloaded: 55476times)

Tip: Excel 97 users can download Name Manager version 3.2 below.

Name Manager for Excel 2007 V4.1 (Build 606, Updated 22 Feb 2009, 743k, downloaded: 10516times)

Solving Compile errors related to Name Manager

Recently, due to an Office update, some users have complained they get a compile error during load of Name Manager: "Compile Error in hidden module, fxlNameManager".

This error is mostly resolved by opening Excel and selecting Help, detect and repair from the menu.

After doing so, Name Manager will work as expected.

New in this build:

606: Suomi (finnish) language added.

600: When detecting unused names, all objects are searched as well as your VBA project.

We've added a tiny but extremely handy toolbar to the VBE:

Selecting a name will paste that name at the current insertion point in your code!

Features:

Sorting of names and refersto formulas
Functionality to edit names that refer to large multiple areas.
Add name dialog
Shortcut key (default control-shift-n) to start Name Manager
Choice between icons on commandbuttons or text labels (see Screenshot).
Rename a name. Name Manager includes a rename option, which will enable you to change the name of a name and have all objects that use that name update too. (this includes VBA)
Show where a name is in use:

International version, screens and messages in national languages:
- English
- Danish
- German
- French
- Dutch
- Brazilian Portugese
- Swedish
- And others...
Analyse Command, allows partial evaluation of names etc.
Many different filter options
Options listbox shows options for:
- Confirm Changes
- R1C1 Notation
- GoTo Selected Names
- Show RefersTo
- Show Excel System Names
- Sort Names (sort local names together by sheet)
Highlight named Ranges
Clear Highlights
Form can be resized, including minimise/maximise buttons and moving of splits

Old versions

Not sure version 4 is stable? Name Manager 3.2 (Downloaded: 3045times) is still available!

Mac users, please note : version 4.0 does not work in the Mac environment, due to the use of Windows API calls. For your convenience, Name Manager 2.3 (Downloaded: 2850times) is still available.

Instructions

Download the zip file by clicking the link above that says "NameManager.zip". Unpack the files in the zip file to a folder of your liking and open the file called "Setup Name Manager.xls". Press the button in that file to install.

Click here to request support or issue comments or suggestions on this product.

Comments

Showing last 8 comments of 275 in total (Show All Comments):

Comment by: Mark Daysh (6/16/2009 6:41:54 AM)

Excellent tool.
This error has been bugging me for ages.
Thank you so much.

Comment by: Jan Karel Pieterse (6/17/2009 1:43:53 AM)

Hi Mark,

You're most welcome!

Comment by: Russ Ford (6/17/2009 12:15:48 PM)

Hi Jan,

I've been using Name Manager for a number of years now and I think it should be included with Excel. It's so handy and is very intuitive. The interface is really robust and well designed. Is all the development done in VBA?

Keep up the awesome work.

Russ

Comment by: Jan Karel Pieterse (6/17/2009 9:23:29 PM)

Hi Russ,

Thanks!
It has all been done in VBA indeed.
Part of the ideas of our Name Manager have been adopted by Microsoft when they were designing their Name Manager for Excel 2007. They even copied our product name!

Comment by: Guy Verlinden (6/21/2009 3:05:24 AM)

When filtering for the names that are "not used", the searchresult of names that are listed, can be dangerous because names used in data validation are still marked as "not used". Or am I doing something wrong?

Anyway, i'm an enthousiastic fan of this add-in!

Comment by: Jan Karel Pieterse (6/21/2009 3:06:35 AM)

Hi Guy,

Thanks for reminding me. Indeed Validation may be an omission from the unused names search.

Comment by: Tai (6/26/2009 3:59:35 AM)

This Add-in is very cool. I have been looking for this for awhile. I started with a simple template with a few defined names. Before long it grew into a long list and unmanageable. Anyhow, I had a hard time keeping track of the names. Until now. Thanks.

I notice that you can output the names in a new worksheet. It would be cool, if I can also do the reverse. For example, I can create a list of name in a table and then turn them into define names.

Again, Thanks.

Tai

Comment by: Jan Karel Pieterse (6/26/2009 4:04:32 AM)

Hi Tai,

Use the button that is right next to the list button (this button appears as soon as you have created a list sheet).

Have a question, comment or suggestion? Then please use this form.

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.