Aspect ratio of a Comment image

  • Thread starter Michael Singmin
  • Start date
M

Michael Singmin

Hello Group,

This is a difficult question on Comments because the renowned expert
on Comments, Debra D, has not found a solution, yet.

I am creating an art gallery in a worksheet. Because Comments are so
economical in storing images, I want to use this method.

Fine art comes in all shapes and sizes.
When the art arrives in the comment, the shape is roughly square.
I have to manually reshape it to get it back to its original aspect.

Is there any VBA code that will achieve the same ?

Thanks,

Michael Singmin
 
T

Tom Ogilvy

Import the image as a picture

get the height and width

set the comment height and width to match

delete the imported image
 
Top