This documentation is archived and is not being maintained.

PictureFormat.CropBottom Property

Office 2007
Returns or sets a Variant indicating the amount by which the bottom edge of a picture or OLE object is cropped. Read/write.



expression   A variable that represents a PictureFormat object.

Return Value


Numeric values are evaluated in points; strings can be in any units supported by Microsoft Office Publisher (for example, "2.5 in").

Negative values crop the bottom edge away from the center of the frame and positive values crop toward the top edge of the frame.

The valid range of crop values depends on the frame’s position and size. For an unrotated frame, the lowest negative value allowed is the distance between the bottom edge of frame and the bottom edge of the scratch area. The highest positive value allowed is the current frame height.

Cropping is calculated relative to the original size of the picture. For example, if you insert a picture that is originally 100 points high, rescale it so that it is 200 points high, and then set the CropBottom property to 50, 100 points (not 50) will be cropped off the bottom of your picture.

Use the CropLeft, CropRight, and CropTop properties to crop other edges of a picture or OLE object.


This example crops 20 points off the bottom of the third shape in the active publication. For the example to work, the shape must be either a picture or an OLE object.

Visual Basic for Applications
ActiveDocument.Pages(1).Shapes(3).PictureFormat _
    .CropBottom = 20

This example crops the percentage specified by the user off the bottom of the selected shape, regardless of whether the shape has been scaled. For the example to work, the selected shape must be either a picture or an OLE object.

Visual Basic for Applications
Dim sngPercent As Single
Dim shpCrop As Shape
Dim sngPoints As Single
Dim sngHeight As Single

sngPercent = InputBox("What percentage do you " & _
    "want to crop off the bottom of this picture?")

Set shpCrop = Selection.ShapeRange(1)
With shpCrop.Duplicate
    .ScaleHeight Factor:=1, _
    sngHeight = .Height
End With

sngPoints = sngHeight * sngPercent / 100

shpCrop.PictureFormat.CropBottom = sngPoints