Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code for pictures in comments
Hi friends
what code do I write to make comment boxes accept pictures thanking you all |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
code for pictures in comments
Look at Debra Dalgleish's site:
http://www.contextures.com/xlcomments02.html#Picture -- Vasant "steve" wrote in message ... Hi friends what code do I write to make comment boxes accept pictures thanking you all |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
code for pictures in comments
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" wrote in message ... Hi friends what code do I write to make comment boxes accept pictures thanking you all |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
printing comments with pictures | Excel Discussion (Misc queries) | |||
VBA code for sizing/showing pictures | Excel Discussion (Misc queries) | |||
how do i change or make this macro??? pictures and code included | Charts and Charting in Excel | |||
HOW CAN I PUT GRAPHICS/PICTURES IN A COMMENTS BOX IN EXCEL | Excel Discussion (Misc queries) | |||
Pictures in comments - Excel 2000 | Excel Worksheet Functions |