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.
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.
