View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AL2000 AL2000 is offline
external usenet poster
 
Posts: 7
Default Naming Auto Shapes and Creating new Shapes

When you create an AutoShape it is automatically given a name like Oval 1,
Oval 2, etc.

Is there a way to change the name that is assigned automatically so that it
is more meaningful, similar to range names?

Is there a way to find a list of all "shape" names on a particular worksheet?

If I wanted to create a special shape, say a smiley face, where the circle
could be filled. I would I go about creating, naming, and saving it?