Excel - Add An Image In The Workbook Header

This macro adds an image to the workbook's header.

Excel

6013
1892
0
0

Add to collection

1 Open MS Excel.

2 Create a blank workbook.

3 Go to Developer's tab > click on "Visual Basic" button or hit Alt + F11.

4 Go to Insert tab > click on "Module" or hit M.

5 Copy the VBA code from below.

6 Paste the code in the newly created module.

7 Go to Run tab > click on "Run Sub/UserForm" or hit F5.

8 That's it!

Code

'==========================================
' Add An Image In The Workbook Header
'==========================================
Sub addImageHeader()
   ' Set image properties
   With ActiveSheet.PageSetup.LeftHeaderPicture
      .Filename = "Path to file"
      .Height = 48
      .Width = 48
   End With
   ' Add image to header
   ActiveSheet.PageSetup.LeftHeader = "&G"
End Sub