Paste picture above Button

[tanvi_kalra]

Is there a way so that i can copy any picture ("Picture 1") from some sheet ("Sheet1") and paste it to all other sheets at just above the print button.

Actually i just want to paste it specifically above the print button not on any specific cell.

[scottlutes]

With a little modification, this should work for you.

Please Login or Register  to view this content.

[tanvi_kalra]

Thanks scottlutes
But i want to paste it above print button. using this code the pic will be pasted at range "A1" .

[tanvi_kalra]

Or can i paste it on the top left visible corner of sheet using vba macro .?

[jmac1947]

how hard is it to change "A1" to a cell immediately above where you have your print button??

we are not mind readers, how can we know where your print button is???

This, among other reasons, is why the volunteers on this site ask you to post a sample workbook with what you have already achieved

[tanvi_kalra]

Actlly i want to paste it on all sheets and print button is on different cells at each sheet. For sharing sample file the data is very large to share as it contains many tabs of data too.