Class Graphic (Excel VBA)

Contains properties that apply to header and footer picture objects.

Properties

Brightness returns or sets the brightness of the specified picture or OLE object. The value for this property must be a number from 0.0 (dimmest) to 1.0 (brightest).

Set myDocument = Worksheets(1) 
myDocument.Shapes(1).PictureFormat.Brightness = 0.3

ColorType returns or sets the type of color transformation applied to the specified picture or OLE object.

Contrast returns or sets the contrast for the specified picture or OLE object. The value for this property must be a number from 0.0 (the least contrast) to 1.0 (the greatest contrast).

Set myDocument = Worksheets(1) 
myDocument.Shapes(1).PictureFormat.Contrast = 0.8

CropBottom returns or sets the number of points that are cropped off the bottom of the specified picture or OLE object.

Set myDocument = Worksheets(1) 
myDocument.Shapes(3).PictureFormat.CropBottom = 20

CropLeft returns or sets the number of points that are cropped off the left side of the specified picture or OLE object.

Set myDocument = Worksheets(1) 
myDocument.Shapes(3).PictureFormat.CropLeft = 20

CropRight returns or sets the number of points that are cropped off the right side of the specified picture or OLE object.

Set myDocument = Worksheets(1) 
myDocument.Shapes(3).PictureFormat.CropRight = 20

CropTop returns or sets the number of points that are cropped off the top of the specified picture or OLE object.

Set myDocument = Worksheets(1) 
myDocument.Shapes(3).PictureFormat.CropTop = 20

Filename returns or sets the URL (on the intranet or the web) or path (local or network) to the location where the specified source object was saved.

ActiveWorkbook.PublishObjects(1).FileName = _ 
 "\\Server2\Q1\StockReport.htm"

Height returns or sets a Single value that represents the height, in points, of the object.

LockAspectRatio true if the specified shape retains its original proportions when you resize it. False if you can change the height and width of the shape independently of one another when you resize it.

Parent returns the parent object for the specified object. Read-only.

Width returns or sets a Single value that represents the width, in points, of the object.