CenterFooterPicture Property

Microsoft Excel Visual Basic

object that represents the picture for the center section of the footer. Used to set attributes about the picture.

expression.CenterFooterPicture

expression    Required. An expression that returns a PageSetup object.

Remarks

The CenterFooterPicture 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 center section of the footer. This example assumes that a file called Sample.jpg exists on the C:\ drive.

Sub InsertPicture()

    With ActiveSheet.PageSetup.CentertFooterPicture
        .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 center footer.
    ActiveSheet.PageSetup.CenterFooter = "&G"

End Sub
		

Note  It is required that "&G" is a part of the CenterFooter property string in order for the image to show up in the center footer.