Excel: Adding Shape and Picture

Is there any way to Lock Aspect Ratio of a Shape Relevant to a Picture that is being added with the shape. Trying to merge the functions together some how. I want to define the largest boarders of the shape but maintain the aspect ratio at the same time and anywhere the ratio falls inside of those boarders are fine. .Shapes.AddPicture, (relevant boarder area) and .LockAspectRatio, True

This question generated 9 answers. To proceed to the answers, click here.

This thread is current as of June 22, 2017.

For more resources for Microsoft Excel