Results 1 to 10 of 10
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Missouri, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Name manager 2.1 released (97, 2000, XP)

    <hr>Matthew Henson (mhenson@mac.com) who ensured the utility works on Mac Excel too.<hr>

    Now, that is good news. I use Excel 2002 at work, but Excel 2001 on a Mac at home. Thank you

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Name manager 2.1 released (97, 2000, XP)

    Jan Karel, your Name Manager is fantastic! I just inherited a bunch of templates for data collection that expected everything to be the same size and in the same place, so there are a lot of named ranges. Now, they have different information in the header and the instrument running at a different resolution, so most all of the named input ranges are in the wrong place and are the wrong size. "Just a few changes" and it will work with the new data! Wrong! without your Name Manager, it would be <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>.

    One simple request, make the List button use the filtered list so you could printout the unused names. One hard request for the wish list, even a simple finder for VBA use of names would be wonderful. Simple being defined as just finding RANGE("xxx"), where xxx is a Name. Thanks again! --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Name manager 2.1 released (97, 2000, XP)

    <hr>use the filtered list so you could printout the unused names<hr>
    Good idea.
    I'll put this on the wish list for a future version.

    <hr>One hard request for the wish list, even a simple finder for VBA use of names would be wonderful. <hr>
    We've thought about that. Another one for the list I guess. But there is also the many objects to search in, if we really want to know whether a name is not used...
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Name manager 2.1 released (97, 2000, XP)

    <hr>But there is also the many objects to search in, if we really want to know whether a name is not used...<hr>
    It's just a simple matter of writing a VBA code parser. <img src=/S/wink.gif border=0 alt=wink width=15 height=15>
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  5. #5
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Name manager 2.1 released (97, 2000, XP)

    If you're adding to your future fix list <img src=/S/duck.gif border=0 alt=duck width=23 height=23> .... how about adding a 'select all' in the With Errors list so I can delete all names with errors in them at once instead of pushing Delete 100 times. I had inherited a workbook with 128 names with errors (out of total of 338) and used NamesManager to get rid of them.

    I did get an error once when I tried to view the contents of a name... I'll test it more and get back with you on how/when it occurs.

    Good job!
    Deb

  6. #6
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Perth, Western Australia, Australia
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Name manager 2.1 released (97, 2000, XP)

    This is a really useful utility and has already saved me quite a lot of work.
    Thank you for making it available.

    One small problem I have found is when filtering for unused names, the utility does not recognise names that are used in the Data Validation function where the validation source is a list having a defined name.
    Another potential addtion to the wish list maybe?

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Name manager 2.1 released (97, 2000, XP)

    No fix needed. If you press the multi button, you are enabled to select (control or shift-click or drag) one or more names in the (filtered) list and hide, unhide or delete them all in one go.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  8. #8
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Name manager 2.1 released (97, 2000, XP)

    Yes, I would really like to add that, but where would I stop:

    - formula property of a picture
    - source range of pivot tables
    - source range of charts
    - formula property of chart titles
    - objects positioned on charts with a formula
    - comboboxes on sheets
    - listboxes
    - spinner controls
    - .....

    And there are more, I'm sure.

    It would indeed be useful, but the effort to build this is tremendous. The time it would take would be equally impressive <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    What I would advise is to download FINDLINK.ZIP from the Excel MVP Page listed below and use that to search for a suspicious name in (nearly) all objects of a workbook. Only drawback is that it only searches one name at the time.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  9. #9
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Name manager 2.1 released (97, 2000, XP)

    > where would I stop
    Don't stop, we love it!

    One for the wish list:
    I usually only want to know if a particular Name is used. Now, I have to filter the entire list to show unused names.

    Thanks again for a very useful tool! I am using it constantly since I am not the author of the books that I am modifying.
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  10. #10
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Name manager 2.1 released (97, 2000, XP)

    <P ID="edit" class=small>(Edited by Leif on 13-Mar-04 17:09. to update link to http://www.bmsltd.ie/)</P>Hi All,

    Here's to announce I've just released a new version of the Name manager utility.

    Find it at http://www.bmsltd.ie/mvp

    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.
    Now available: version 2.1 of the name manager, created in collaboration with Charles Williams, www.decisionmodels.com and Matthew Henson (mhenson@mac.com) who ensured the utility works on Mac Excel too.
    Quite some new features have been added!!!
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •