Thank you so much for your reply. It is very helpful. I hope you can
help again by answering a follow-up question. How do i know the names
of the shapes in my spreadsheet? Is it the filename of the picture.
Is it assigned by excel when the shape is inserted or drawn. I have
two shapes i am dealing with, 1 picture inserted, and 1 line drawn.
Ultimately, I want to programmatically draw this line and insert this
picture as well as "arrange" it, any help or direction you can give me
on those tasks would be awesome also.

Thanks for your help.

Natan

On Dec 2, 4:32*pm, "Rick Rothstein"
wrote:
Just remembered... you wanted to send the picture to the back, not bring it
to the front... use the SendToBack method instead of the BringToFront method
that I showed in my previous message.

WS = "Sheet1"
SH = "Picture 1"
Worksheets(WS).Shapes(SH).OLEFormat.Object.SendToB ack

--
Rick (MVP - Excel)

"Rick Rothstein" wrote in message

...



Give this a try...

WS = "Sheet1"
SH = "Picture 1"
Worksheets(WS).Shapes(SH).OLEFormat.Object.BringTo Front

Change the sheet name and and shape name that are assigned to the WS and
SH variables to match your actual conditions.

--
Rick (MVP - Excel)

"natanz" wrote in message
....
I found a macro that helped me insert a picture (jpeg file) in an
excel spreadsheet. *Now I am looking for a way to send that element in
back of other elements on the spreadsheet. *I have tried to record a
macro to figure out the methods and procedures, but apparently the
"send to back" buttons and "bring to front" are invisible to the macro
recorder. *I found that the insert/shape/line tools are also
invisible. *Finding a way to draw a line would be equally effective,
because if it is drawn following the insert it will effectively be on
top, which will meet my needs.

i appreciate any help you can provide. *Thanks.

Natan- Hide quoted text -

- Show quoted text -