I have a workbook with 12 sheets. Each sheet has a picture in it of the company logo. The logo is usually the same size, but can change a bit by sheet.
The logo is usually in a different place in each - e.g. in one sheet it might cover cells E3 to G5, whereas in another sheet it could be D3 to F5.
It never overlaps with any other pictures or charts. However, there are other pictures and charts in other locations in most sheets.
What I would like to do is have a macro that replaces the logo on each sheet with a new company logo. I will always use the same picture for the new logo - I plan to call it "New_Logo".
For each sheet I can tell the macro a cell that is completely covered by the current logo on that sheet.
Could anyone give me the guts of the code to cycle through the sheets, identify and delete the old logos, and put the new one in the same position as the old?
Thanks,
MikeG
The logo is usually in a different place in each - e.g. in one sheet it might cover cells E3 to G5, whereas in another sheet it could be D3 to F5.
It never overlaps with any other pictures or charts. However, there are other pictures and charts in other locations in most sheets.
What I would like to do is have a macro that replaces the logo on each sheet with a new company logo. I will always use the same picture for the new logo - I plan to call it "New_Logo".
For each sheet I can tell the macro a cell that is completely covered by the current logo on that sheet.
Could anyone give me the guts of the code to cycle through the sheets, identify and delete the old logos, and put the new one in the same position as the old?
Thanks,
MikeG
