View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Unlocking Aspect Ratio For images

Some aspects of the macro recorder appear not to have been designed at all,
yet only badly!

courtesy of 2003 -
Selection.ShapeRange.LockAspectRatio = msoFalse / msoTrue

or
myShape.LockAspectRatio = bFlag

Regards,
Peter T

"ironhydroxide" wrote in message
...
I am wondering how one Unlocks the aspect ratio for inserted images. The
2007 Macro recorder was poorly designed in comparison with 2003. (it
seems
like it is missing alot) anyways it doesnt record the changes in size
and
properties of the image when i record then manually change the properties
(uncheck Lock Aspect Ratio).

Thanks in Advance

Ironhydroxide