code for pictures in comments

Hi friends
what code do I write to make comment boxes accept pictures
thanking you all

Look at Debra Dalgleish's site:

http://www.contextures.com/xlcomments02.html#Picture

--

Vasant

"steve" <steve@discussions.microsoft.com> wrote in message
news:5C311678-C909-46FD-8CAE-678114C77D95@microsoft.com...
> Hi friends
> what code do I write to make comment boxes accept pictures
> thanking you all

This method does not work in Excel 2002, and perhaps not in 2000. The
"PastePic" solution here does work for 2002:
http://www.bmsltd.ie/Excel/Default.htm . I suggest modifying the code to
save the pic as a temporary bitmap file, attaching it to the comment, and
deleting the image. Excel will store the BMP in the worksheet.

My only problem with this is that the images don't print out, since this
method makes the image the Background of the comment. Does anyone know how
to overcome this?

Thanks

"Vasant Nanavati" wrote:
> Look at Debra Dalgleish's site:
> http://www.contextures.com/xlcomments02.html#Picture
>-------------------------------------------------
> "steve" <steve@discussions.microsoft.com> wrote in message
> news:5C311678-C909-46FD-8CAE-678114C77D95@microsoft.com...
> > Hi friends
> > what code do I write to make comment boxes accept pictures
> > thanking you all
>
>
>