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 601 ,Updated 24 Apr 2008, 736k, Downloaded: 39452 times)
Name Manager for Excel 2007 V4.1 (Build 601, Updated 24 Apr 2008, 743k, downloaded: 5441 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: 2088 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: 2214 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: 646 times, average rating: 6.2)

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

Comment by: Jan karel Pieterse (2/26/2008 11:17:14 PM)

Hi Matthew,

It refreshes with switching of workbooks. Might be nice to have a refresh button though.

Comment by: THughes (3/5/2008 2:51:40 PM)

Just downloaded and installed the name manager - version 4.1 build 596.

All works well in Excel however I am un able to use or find for that matter the "niffty" feature added to the VBE - the insert name drop down tool bar. That would be most usefull. Is there some action within VBE that must be taken to make it work? or is there some place to select and enable it?

Many Thanks for your hard work,

Tom

Comment by: Jan karel Pieterse (3/6/2008 9:00:58 AM)

Hi Tom,

I think you need to set "Allow access to Visual basic project" in Tools, Macro, security, trusted sourcs tab.

Comment by: Dave B (3/11/2008 11:44:32 AM)

Jan,

Sorry it took so long to get back to you, but I did try to install under another user and it had the same issue. I don't know if this helps, but I have seen issues with several programs installing on my machine due to the Windows File Encryption applied to the User Folders in our Corporate environment. Usually, this is an issue with programs that attempt to authenticate the file that is being installed because the encrpytion alters the size or signature slightly and when the installer compares it to what is expected it doesn't match.

Comment by: Matthew (3/14/2008 7:14:52 AM)

When searching for unused named ranges, would it be possible to enable searching of INDIRECT, conditional formulae, etc. with the understanding

that the process will take a long time? Or has this process not been included due to its complexity?

Comment by: Jan karel Pieterse (3/14/2008 7:15:42 AM)

Hi Matthew,

Of course we could. We just haven't got round to it, that's all.

Thanks.

Comment by: Ng C C (3/22/2008 9:50:45 PM)

Hi,

Judging from what I read in this webpage, I certainly believe that this is a great tool.

I have downloaded it and add to my excel 2003 but hit an error Massage as follows:-

"Compile Error in Hidden Module: fx|NameManager."

Kindly advise what is the cause of it and how I can have it fixed.

Thanks

Ng C C

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

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