LeftHeaderPicture Property

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Returns a Graphic object that represents the picture for the left section of the header. Used to set attributes about the picture.

expression.LeftHeaderPicture

expression   Required. An expression that returns a PageSetup object.

Remarks

The LeftHeaderPicture property is read-only, but the properties on it are not all read-only.

Example

The following example adds a picture titled: Sample.jpg from the C:\ drive to the left section of the header. This example assumes that a file called Sample.jpg exists on the C:\ drive.

  Sub InsertPicture()

    With ActiveSheet.PageSetup.LeftHeaderPicture
        .FileName = "C:\Sample.jpg"
        .Height = 275.25
        .Width = 463.5
        .Brightness = 0.36
        .ColorType = msoPictureGrayscale
        .Contrast = 0.39
        .CropBottom = -14.4
        .CropLeft = -28.8
        .CropRight = -14.4
        .CropTop = 21.6
    End With

    ' Enable the image to show up in the left header.
    ActiveSheet.PageSetup.LeftHeader = "&G"

End Sub

Note   It is required that "&G" is a part of the LeftHeader property string in order for the image to show up in the left header.