Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
Not spamming, just announcing a new version of my free Name Manager is out: 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, who ensured the utility works on Mac Excel too. New in version 4.0: 1. 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. 2. Show where a name is in use. http://www.jkp-ads.com/officemarketplacenm-en.asp Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Jan, great utility, thanks
Greg Jan Karel Pieterse wrote: Hi all, Not spamming, just announcing a new version of my free Name Manager is out: 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, who ensured the utility works on Mac Excel too. New in version 4.0: 1. 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. 2. Show where a name is in use. http://www.jkp-ads.com/officemarketplacenm-en.asp Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Keep scrolling until mouse released | Excel Programming | |||
From where i can get list of all released version number of Excel | Excel Discussion (Misc queries) | |||
object reference not released when using ADO.NET | Excel Programming | |||
Name manager version 3 Beta | Excel Programming | |||
excel not being released by vb.net | Excel Programming |