VBA Code for Resizing Photos/Objects

[jkjuliek]

HI!

Can anyone help me with figuring out the VBA code to unselect "Lock aspect ratio" and unselect "Relative to original picture size" and then resize all images and object in the active worksheet to a specific height and width?

Thank you in advance.

-Julie!

 

[KOKOSEK]

This works for me:

ActiveSheet.Shapes.Range(Array("Picture 2")).Select
    Selection.ShapeRange.LockAspectRatio = msoFalse