View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lazzaroni Lazzaroni is offline
external usenet poster
 
Posts: 55
Default Cannot Find Object "Lock Picture Aspect Ratio"

Can someone please tell me the object for "lock picture aspect ratio" for
pictures used in comments?

I want to programmatically prevent a photo from being distorted after I add
it to a comment box using the following code:
Selection.AddComment.Shape.Fill.UserPicture (Selection.Value)

I have found Selection.Comment.Shape.LockAspectRatio. But that only locks
the aspect ratio of the comment box itself, not the photo.

This is done conventionally in Excel in the following manner:
[Right-click comment border] Format Comment€¦ Colors and Lines [tab]
Fill: Color: Fill Effects€¦ Lock picture aspect ratio.

Thanks for your help.