How to put the image under the text

Help! I can add an image (.jpg) to Excel through Shapes->AddPicture,
but how to put the image under the text, I have tried
sShape->ZOrder(Office::msoSendBehindText); no lucky.

anyone can help?

you cant.
the "cells" layer is always below any shapes.

the only exception being the (totally useless)
worksheet background image





--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Jimmy wrote :

> Help! I can add an image (.jpg) to Excel through Shapes->AddPicture,
> but how to put the image under the text, I have tried
> sShape->ZOrder(Office::msoSendBehindText); no lucky.
>
> anyone can help?

Thanks keepITcool,
I saw one OCX control can do that.but i don't know how?(no source code)
if the sShape can't,is there any other way?

thanks again.

*** Sent via Developersdex http://www.developersdex.com ***

put the text in a shape and
Zorder the text above the picture.

else buy the OCX.

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Jimmy zhuh wrote :

>
>
> Thanks keepITcool,
> I saw one OCX control can do that.but i don't know how?(no source
> code) if the sShape can't,is there any other way?
>
> thanks again.
>
> *** Sent via Developersdex http://www.developersdex.com ***

I'm surprised an OCX exists that can do that but I suppose anything is
possible.

If all you want to do is display some text over your picture you could put
it in a textbox from the Drawing toolbar. Format Fill to No Fill and maybe
Line to no line. You could link to a cell, select the textbox, then in the
inputbar =A1 and enter.

Regards,
Peter T

"Jimmy zhuh" <[email protected]> wrote in message
news:[email protected]...
>
>
> Thanks keepITcool,
> I saw one OCX control can do that.but i don't know how?(no source code)
> if the sShape can't,is there any other way?
>
> thanks again.
>
> *** Sent via Developersdex http://www.developersdex.com ***