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.
|