Class Graphic (Excel VBA)

Contains properties that apply to header and footer picture objects.

The classes HeaderFooter and PageSetup. give access to class Graphic

Member in collection

Item

To use a Graphic class variable it first needs to be instantiated, for example

Dim grp as Graphic
Set grp = ActiveChart.PageSetup.CenterFooterPicture

The following procedures can be used to set variables of type Graphic: HeaderFooter.Picture, PageSetup.CenterFooterPicture, PageSetup.CenterHeaderPicture, PageSetup.LeftFooterPicture, PageSetup.LeftHeaderPicture, PageSetup.RightFooterPicture and PageSetup.RightHeaderPicture.

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).

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).

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

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

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

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

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.

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.

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