Graphic object (Excel)

Contains properties that apply to header and footer picture objects.

Remarks

Use the following properties of the PageSetup object to return the Graphic object:

• CenterFooterPicture
• CenterHeaderPicture
• LeftFooterPicture
• LeftHeaderPicture
• RightFooterPicture
• RightHeaderPicture

Note

For an image to show up in the left footer, "&G" needs to be a part of the LeftFooter string.

Example

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

Sub InsertPicture() 
 
 With ActiveSheet.PageSetup.LeftFooterPicture 
 .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 footer. 
 ActiveSheet.PageSetup.LeftFooter = "&G" 
 
End Sub

Properties

• Application
• Brightness
• ColorType
• Contrast
• Creator
• CropBottom
• CropLeft
• CropRight
• CropTop
• Filename
• Height
• LockAspectRatio
• Parent
• Width

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.