Thread: name a picture
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default name a picture

Sheet1.Shapes("Picture 107").Name = "MyPicture"

If you post your code, there may be a more direct way of doing it.

--

Vasant



"Darryl" wrote in message
...
Greetings,
I have a picture object in workbook A Sheet 1.
I can programatically copy it from Workbook A Sheet 1 to
Workbook B sheet 1. Is there a method that I can give it
a name, instead of excel naming it picture 107, etc ?

thanks,
D