• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Clear names from shapes (lines)

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
 
Goto the worksheet which contains the lines
Goto Page Layout Selection Pane
Ctrl A
Click on any Objects you want to keep to unhighlight them
Delete
 
Back
Top