PolarSpartan
New Member
I'm using some vba code to change the color of lines that make up a drawing. The color changes represent the completion of work on a project that the lines map out.
I made the mistake of copy and pasting the first line segment to make up the rest of the lines. I had named that first segment using the Name Box. Now all of the lines (several hundred) have the same name.
I need to be able to clear the names off of those lines to be able to give them unique names that will work with the VBA code. The name box does not allow me to change the original shape names.
Any ideas for clearing these names would be appreciated.
thanks
I made the mistake of copy and pasting the first line segment to make up the rest of the lines. I had named that first segment using the Name Box. Now all of the lines (several hundred) have the same name.
I need to be able to clear the names off of those lines to be able to give them unique names that will work with the VBA code. The name box does not allow me to change the original shape names.
Any ideas for clearing these names would be appreciated.
thanks