View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Naming of wordart

Rename "WordArt 32" on your original sheet, eg "myWordArt". Then when you
copy it to another sheet it's name should persist. Be aware, doing that you
can end up with multiple shapes on the sheet with the same name.

Regards,
Peter T


"Mike D." wrote in message
...
I have a wordart ("WordArt 36") that is referenced in a macro.

When I copy the worksheet to another worksheet, the name of this changes

to
"WordArt 32"

Is there a way to copy the worksheet so that the name of the images stay

the
same?

Or, is there a way to rename the wordart to the previous name?