Code to Delete a defined name

  • HI all


    i have several items (List) in column c........
    I defined the items as names through the name dialoge box ..........
    NB: i defined the items giving them the same names as they appera in the list.


    when i wnat to delete an item, i do this through inputbox....
    see macro below...................
    the chosen item is successfully deleted from the list (column c), but i have a problem deleting the chosen name from the name dialoge box...


    i tried, but...........pls see macro below


    any ideas are appreciated in advanced


    yours............hesham



    As you see, when i specify the name the code works fine, but when i use the vInput2 (that carry the chosen name) to delete it from the name dialoge box, does not work.....................................

    ******************
    [SIZE=6]Yours
    h [/SIZE]

    Your Help Is Highly Appreciated

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!