• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA - reduce width of multiple images at once, with conditions

navic

Active Member
I have found several VBA macros that resize multiple images. But it's not what I'm looking for.
It is necessary to select all images on Worksheet and to reduce with scale their size but under certain conditions.

The criterion is following.
1) If the image width is greater than 7.89 cm, it is necessary to reduce the image width to 7.89 cm
2) If the image is smaller than 7,89 cm, then it should remain the same width (It is not necessary to change the width)
3) Reduced pictures should keep proportional scaling.

Please see attached example. Thanks advance.
 

Attachments

  • examplescaleimage.xlsx
    42.5 KB · Views: 2
navic
How many different version would You have?
... press the button
 

Attachments

  • examplescaleimage.xlsb
    46 KB · Views: 2
Back
Top