select specific objects by names or by nature

[iaudio1233]

Hi,

Is there any command or simple vba to select specific objects or images ?

case :
20 triangles in the names : "triangle1"....."triangle20" and 20 circles.."circle1"..."circle20"
a.just want to select the triangles
b. rename each to "shape01"...."shape20"


Regards,

iaudio1233

 

[MickG]

Great, I'm very pleased its working for you.!!
Regrds Mick

 

[jrickards]

I have a similar question except the shape is a Polyline. I tried looking for msoPolyline but it didn't seem to come up.

The problem I'm trying to resolve is that I have a command button on the spreadsheet that activates the creation of a polyline but before it draws it, it deletes all shapes that exist on the page which also seems to delete the command button. If I can limit the deletion of shapes to just the polyline, then the button should stay. (or the other choice is to run the delete routine but if it encounters the command button, to not delete it).