Hi all.
I can insert picture to the header of my excel sheet using the below codes
VB Code:
Dim oSW As Excel.Worksheet 'Add picture at left header Set oSW = Worksheets(1) With oSW.PageSetup.LeftHeaderPicture .FileName = (App.Path & "/Pic.jpg") .Height = 50 End with
But the problem is my data on the excel sheet will cover part of the picture in the header. (See attached image)Why is this so that data can be mixed with header of the worksheet? any solutions?




Reply With Quote