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!