JKP Application Development Services.

Microsoft Office Application Development

Name Manager

Up • Name Manager • Flexfind

• •

Search

Zoeken

Go to	Ga Naar
Home Up

Donate	Donaties
Did you find something helpful on my site? Consider a donation! Heeft u iets gevonden waar u wat aan had? Overweeg dan een donatie!

Name Manager for Excel

Current version

Name Manager for Excel 97, 2000, XP and 2003 v4.1 (Build 603 ,Updated 13 May 2008, 736k, Downloaded: 41575 times)
Name Manager for Excel 2007 V4.1 (Build 603, Updated 13 May 2008, 743k, downloaded: 6095 times)

Screenshot
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.

New in this build:

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!

New in version 4.0:

	Rename a name. Name Manager now 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.
	Show where a name is in use:

Other features:

	Enabled form resizing (including minimise/maximise buttons) and moving of splits
	Sorting of names and refersto formulas
	Add name dialog
	New filter: active sheet
	When more than one name is selected, offer to just highlight those names
	Shortcut key (default control-shift-n) to start Name Manager
	Choice between icons on commandbuttons or text labels (see Screenshot).

International version, screens and error messages in national languages:

	English
	Danish
	German
	French
	Dutch
	Brazilian Portugese
	Swedish

Analyse Command, allows partial evaluation of names etc.

Defaults to Multi mode, with option to show Refersto

Choice of And/Or for type filter

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)

Language changer

Highlight Ranges

Clear Highlights

Functionality to edit names that refer to large multiple areas.

Old versions

Not sure version 4 is stable? Name Manager 3.2 (Downloaded: 2231 times) 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: 2301 times) 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

Please rate this utility:

(Rated: 696 times, average rating: 6.1)

Showing last 15 comments of 205 in total (Show All Comments):

Comment by: Jan karel Pieterse (3/24/2008 7:42:54 AM)

Hi NG,

Try cleaning out your temp folder and removing all .exd files from this folder:

C:\Documents and Settings\[your Username]\Application Data\Microsoft\Forms

Comment by: Dave Mackmiller (4/1/2008 8:18:16 AM)

Jan,

Thanks for the useful tool. I've been using it for a couple of years now. Funny, I also wrote a utility similar to your "Highlight" function, and never noticed that you had one too. The only difference, which I prefer, is that the name of the range is displayed in the upper right hand corner of the text box in 10 point Arial bold. This means that I don't have to scroll around and/or zoom to find the name. Most of my ranges are of different sizes, so this makes it easier to work with.

Also, I only highlight ranges on the active sheet, for speed purposes.

Another thing I found handy is a "Highlight for 5 seconds" command. I'm usually in the area where I know the range is that I'm looking for, so I only need to be reminded briefly (it also closes the utility userform). I just use application.ontime to call my sub for clearing highlights.

Finally, it wasn't too hard to reuse the textbox code to highlight cells that are unlocked. I know it's outside of the scope of NameManager, but it's very useful if you have to protect your worksheets. The trick there is to combine blocks of unlocked cells into a single textbox so you don't potentially wind up with a zillion textboxes.

Anyhow, thanks again for a great tool.

Dave

Comment by: Headtoadie (4/2/2008 8:23:54 AM)

On the "Filter names containing" text box, could you make it so there is an option to exclude items. I usually don't want to see print areas and there is no simple way to not display them in the range name list.

Comment by: Jan Karel Pieterse (4/3/2008 1:05:13 AM)

You can do that by unchecking the "Show system names box in the tiny settings list.

But the "Exclude names" filter IS a good idea!

Comment by: Jan Karel Pieterse (4/3/2008 1:06:15 AM)

Hi Dave,

Good point on the position of the text.

Comment by: kp (4/22/2008 6:57:08 PM)

Thank you so much for sharing the fruit of your hard work to others.

I've just road tested it and found that this is an excellent tool. Thanks again.

Regards

Comment by: kanwaljit Singh Dhunna (4/29/2008 5:33:37 AM)

Hi Jan,

Do mention the changes made in the new version by default. That would be useful I feel.

Regards

CA Kanwaljit Singh Dhunna

Comment by: David (4/30/2008 1:41:23 PM)

I'm not getting the tool bar in the VBE, can you tell me how to load it (using 2003)?

Thanks!

David

Comment by: Roemer (5/13/2008 5:17:17 PM)

Hi there.

Perfect, I've been using this utility for more than a year and am very satisfied.

However, I cannot find the "tiny but extremely handy toolbar to the VBE" in the

newest version. Office 2007.

Comment by: Jan Karel Pieterse (5/14/2008 2:05:19 AM)

Hi Roemer,

It shows up in the Visual Basic Editor if you have the option "Allow Access To

Visual Basic project" checked in Excel's security center.

Comment by: Josh (6/4/2008 6:50:57 AM)

Thank you for this utility. It has saved my life at work enabling me to manage hundreds of trend models that

change dynamically off of named ranges that utilize indexes and other programming. Great job!

Comment by: Alan Bradshaw (6/15/2008 3:23:15 AM)

Jan Karel,

Firstly thank you for a wonderful programme, I use Virgin Media PCGuard and it

lists Name Manager 2007.xlam as a possible virus, so I have to keep reloading it. I

would be interested to know if anyone else experiences this.

Regards

Braddy

Comment by: Jan Karel Pieterse (6/15/2008 5:11:24 AM)

Hi Braddy,

I guess you should try to set an exception to name manager in your virus software,

as NM contains no virusses.

Comment by: Anton de la R (6/19/2008 1:19:33 AM)

Hi Jan-Karel,

Many thankx for this great tool!

Kind Regard/Met Vriendelijke Groet

Anton

Comment by: George (6/23/2008 1:46:05 PM)

This is a GREAT tool!

Add a comment too!!!

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

Subscribe in a reader