Same Picture on multiple Sheets

[ElvisHess]

I currently have a spreadsheet that requires the same picture on each of the 7 worksheets within the spreadsheet. I have to go into each page and insert it seperatly now. Does anyone know of a way I can insert it once and have it automatically show up on the other 6 pages.

Thanks in Advance

 

[taigovinda]

I'm not sure why it's not selecting that cell.. This line was supposed to do that:

'FINISHED DELETING OLD PICTURES
    page.Range("BQ6").Select

...maybe try adding the part in red, but I don't know if that will help.

You're saying that if you select BQ6 on every sheet before running this, then it works? If the first thing doesn't work, maybe try adding this in closer to the top:

For Each page In Sheets
    page.Activate
        page.Range("BQ6").Select
    ActiveSheet.Unprotect Password:="elvis1"

 

[ElvisHess]

I chose the 2nd option and it works like a charm.

Thank you very much!!

 

[Draught4me]

One way, though the resolution won't be quite perfect on the copies, is to have the picture be located on one page, and have the pictures on the other 6 pages be linked to *the cell(s) containing* the picture.

You can try it out as follows:

Put the picture on one page, say Sheet1.
Copy the picture.
Paste it to another page.
Click on the copied picture, then click into the formula bar and type =Sheet1!$A$1

...Your picture copy is now linked to cell A1 on Sheet1. If, before doing the copying and linking, you make sure that your picture is sitting exactly in the cell(s) on Sheet1 - in this case cell A1 - then it doesn't look too bad. Especially if every time you replace the picture, it is the same size and you can put it into the cell(s) without changing their dimensions. Depending on how you finesse it, the linked pic can be more or less distorted.

Of course, you could probably mess around with your header or footer in order to get the picture to be where you want it... Then you could do page setup for all sheets at the same time, and change out the picture that-a-way.

Schielrn, I tried your suggestion and I don't think you can work with objects while multiple sheets are selected...

Thankyou for this !! I spent a few hours (over a few weeks) trying to work this out. Only thing I did differently was to merge a large area on one sheet and name it 'pic'. Then followed your instructions and it works perfectly. Now I have to do the same thing, but with a logo, and about seven conditional arguments. That shoud be fine.
Thanks again for your help !!