I've searched the form and found http://www.mrexcel.com/forum/showthread.php?t=145934&highlight=vba+comment+lock+aspect -- however, it does not answer the question I have.
I've used the macro recorder on a cell with a comment, containing a picture, to generate the following code...
During the macro recording I changed the "Lock Aspect Ratio" checkbox to either on/off. However, code does not get generated to make this change.
Can someone help by giving me a statement that would set the "Lock Aspect Ratio" either on or off?
I've used the macro recorder on a cell with a comment, containing a picture, to generate the following code...
Code:
Sub Comment_Chg_LockAspectRatio()
Selection.ShapeRange.Fill.Transparency = 0#
Selection.ShapeRange.Line.Weight = 0.75
Selection.ShapeRange.Line.DashStyle = msoLineSolid
Selection.ShapeRange.Line.Style = msoLineSingle
Selection.ShapeRange.Line.Transparency = 0#
Selection.ShapeRange.Line.Visible = msoTrue
Selection.ShapeRange.Line.ForeColor.RGB = RGB(0, 0, 0)
Selection.ShapeRange.Line.BackColor.RGB = RGB(255, 255, 255)
Selection.ShapeRange.Fill.Visible = msoTrue
Selection.ShapeRange.Fill.ForeColor.RGB = RGB(255, 255, 255)
Selection.ShapeRange.Fill.BackColor.RGB = RGB(255, 255, 225)
Selection.ShapeRange.Fill.UserPicture "image12.gif"
End Sub
Can someone help by giving me a statement that would set the "Lock Aspect Ratio" either on or off?