PictureFormat Object [Excel 2003 VBA Language Reference]
Contains properties and methods that apply to pictures and OLE objects. The LinkFormat object contains properties and methods that apply to linked OLE objects only. The OLEFormat object contains properties and methods that apply to OLE objects whether or not they're linked.
Using the PictureFormat Object
Use the PictureFormat property to return a PictureFormat object. The following example sets the brightness, contrast, and color transformation for shape one on
myDocument and crops 18 points off the bottom of the shape. For this example to work, shape one must be either a picture or an OLE object.
Set myDocument = Worksheets(1) With myDocument.Shapes(1).PictureFormat .Brightness = 0.3 .Contrast = 0.7 .ColorType = msoPictureGrayScale .CropBottom = 18
Properties | Application Property | Brightness Property | ColorType Property | Contrast Property | Creator Property | CropBottom Property | CropLeft Property | CropRight Property | CropTop Property | Parent Property | TransparencyColor Property | TransparentBackground Property