Hi
I am trying to insert a picture in a header of an Excel File. It is clear to me how to do it from a local file in the hard disk, what I can not figure it out is:
if the picture is one in a sheet from the same Workbook, as example:
Code
ActiveSheet.PageSetup.RightHeaderPicture = Sheets("datasheet").Shapes.Range(Array("myLogo"))
With ActiveSheet.PageSetup
.RightHeader = "&G"
End With
can anyone help me to figure it out?
thanks in advance for your support