View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Cush Cush is offline
external usenet poster
 
Posts: 126
Default Quite the challenging question

Gord,
This is quite a neat trick.
One comment: when I try it, the resulting table image is a bit fuzzy.
Is there a way to improve the resolution of the comment image?
Thanks

"Gord Dibben" wrote:

Select the range then SHIFT + EditCopy PictureAs shown on screenPicture

Open the clipboard by StartRun clipbrd.exe

Save As myname.clp

Use your favorite graphics conversion program to convert myname.clp to
myname.jpg

I use IrfanView from http://www.irfanview.com/

Now.......to the comment.

Insert a comment and right-click on edge of comment and Format CommentColors
and LinesClick on the drop-down and "Fill Effects"Picture.

Browse to myname.jpg and d-click and you're done.


Gord Dibben MS Excel MVP

On Sat, 26 Aug 2006 20:13:18 +0200, "Ron de Bruin"
wrote:

Hi Albert

Not that I know
Maybe you can do it with a picture
http://www.contextures.com/xlcomments02.html#Picture