Thread: Change Picture
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Javed Javed is offline
external usenet poster
 
Posts: 91
Default Change Picture

On May 13, 12:59*am, B Lynn B
wrote:
After using the 2007 ribbon menus to insert a picture on my sheet, I can
right click the picture and get an option to "change picture". *But macro
recorder doesn't capture this, and I've had a hard time finding the answer in
the object model reference. *What is the code equivalent of "change picture"?
*Please and thanks!


You can use following:

Worksheets("Sheetname").Pictures.Insert "Filename"

Don't ask me why the pictures object not in Object model of Sheet
object.Ask MS.