expression.ScaleHeight(Factor, RelativeToOriginalSize, Scale)
expression Required. An expression that returns one of the objects in the Applies To list.
Factor Required Single. Specifies the ratio between the height of the shape after you resize it and the current or original height. For example, to make a rectangle 50 percent larger, specify 1.5 for this argument.
RelativeToOriginalSize Required MsoTriState. True to scale the shape relative to its original size. False to scale it relative to its current size. You can specify True for this argument only if the specified shape is a picture or an OLE object.
MsoTriState can be one of these MsoTriState constants. |
msoCTrue |
msoFalse |
msoTriStateMixed |
msoTriStateToggle |
msoTrue |
Scale Optional MsoScaleFrom. The part of the shape that retains its position when the shape is scaled.
MsoScaleFrom can be one of these MsoScaleFrom constants. |
msoScaleFromBottomRight |
msoScaleFromTopLeft default |
msoScaleFromMiddle |
Example
This example scales all pictures and OLE objects on myDocument
to 175 percent of their original height and width, and it scales all other shapes to 175 percent of their current height and width.
Set myDocument = ActiveDocument
For Each s In myDocument.Shapes
Select Case s.Type
Case msoEmbeddedOLEObject, msoLinkedOLEObject, _
msoOLEControlObject, _
msoLinkedPicture, msoPicture
s.ScaleHeight 1.75, True
s.ScaleWidth 1.75, True
Case Else
s.ScaleHeight 1.75, False
s.ScaleWidth 1.75, False
End Select
Next