VBA for all sheets instead of just one sheet

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!

its picture.jpg - ignore the erroneous slash. The code works great I just want to tweak it to do it to all sheets.

Thank you, it looks promising. I just tested it and it returns "Compile error: For without Next" I wish I knew what that meant but I'm new to this.

It worked! You've saved me a ton. Thank you so much!