method to format comment "lock aspect ratio" setting all to "true" under "size" tab...

[sadams1]

I have the following to set "shadow" to false but don't know how to do the same for the "lock aspect ratio" setting to true.


Sub Comments_Format()
Dim cmt As Comment
For Each cmt In ActiveSheet.Comments

cmt.Shape.Shadow.Visible = msoFalse

Next cmt
End Sub


Where would I find this method?
Thanks!
Steve

 

[igold]

How about:

cmt.Shape.LockAspectRatio = msoTrue

 

[sadams1]

How about:

cmt.Shape.LockAspectRatio = msoTrue

SWEET! Greatly appreciate it.
I've been looking for the toggle under the "lock aspect" for "relative to original size" but this looks different. This is what I've found:

ShapeRange.ScaleHeight Method (Excel)

So tried something like this but can't get it to work (I'm definitely not a programmer!)

cmt.Shape.ScaleHeight 1, msoTrue = msoTrue

Am I close?

 

[igold]

Thanks for the feedback. Unfortunately, I do not know the answer to your question.

Good Luck!