Hello everyone,
I have a macro that inserts a picture in the right header of the worksheet that is currently active. I want it to be so that it puts it in all worksheets, or even all selected worksheets, instead of just one worksheet at a time.
Here is my code:
Sub InsertLogo()
With ActiveSheet.PageSetup.RightHeaderPicture
.Filename = "Picture/jpg"
.ColorType = msoPictureAutomatic
End With
' Enable the image to show up in the right header.
ActiveSheet.PageSetup.RightHeader = "&G"
End Sub
I have been trying to figure this out all afternoon. Thank you so much for the help!
Bookmarks