Lock Aspect Ratio of Inserted Comment Picture - Excel 2011 for Mac

[gwlip]

Hi all,

I have a script that adds a picture and resizes it. How do I lock the aspect ratio of the image attached?
My script is below ... I thought it should work correctly with the last line? Any help is appreciated! Thanks!

ActiveCell.AddComment.Text ""
ActiveCell.Comment.Shape.Fill.UserPicture MyFiles
ActiveCell.Comment.Shape.Height = 300
ActiveCell.Comment.Shape.Width = 300
ActiveCell.Comment.Shape.LockAspectRatio = msoTrue

 

[Jim Gordon]

Using the macro recorder I found that this line does work:

Selection.ShapeRange.LockAspectRatio = msoTrue

 

[gwlip]

I tried that with my overall script - doesn't work

 

[Jim Gordon]

I tested it before posting. Perhaps there's some other syntax error in your code.

 

[gwlip]

I think the issue for me here is that I am trying to lock the aspect ratio of the image used in the comment box (so that the uploaded image's aspect ratio is correct compared to the original image).
I believe locking aspect ratio only works for the comment box but this does not affect the image that i have uploaded?
I do not think there is a way to do this via Excel or VBA correct me if I am wrong?

 

[Jim Gordon]

I do not know of any way to format the properties of an image that is placed within a comment box.