View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Resize comments with only picture.

There are two approaches, read the image size from file or assign the image
to an autosize image control are read its dimensions. Examples of both in
this thread -

http://groups.google.co.uk/group/mic...482ba3a32633b1

For your purposes there's a complete example of formatting a comment with a
picture and sized to original picture size.

Regards,
Peter T




"Joergen Bondesen" wrote in message
...
Hi NG

I'm using comment to displaying pictures.

Is it possible to resize comments to the size of the picture, by using a
macro?

--

Best regards
Joergen Bondesen