Insert image to multiple sheets

Hi,

I'm pretty new to excel and VB but you guys helped me out so much on my last post I thought I would try again. I have a workbook with several sheets on it and many sheets have an image in Cell B11. I want to be able to run a macro from Sheet1 that will insert an image to Sheet4, Sheet5, Sheet6, and Sheet7 in Cell B11. I also would like to make sure the image appears in a certain size. If there is already an image in B11 then that image should be removed and replaced by the new image. I found a macro that will insert the picture in the same sheet, but I can't figure out how to do this across multiple sheets or how to make sure the image is viewed in a certain size.

I have attached a sample of the macro I found. I will ultimately try to put this in a workbook with over 100 sheets and most of them need the image inserted.

Thanks for any help.

Bump, no response. Does anyone know if this is even possible?

Thanks John for the response and the macro, but I am getting an error:

Run-time error '1004':
Unable to get the input property of the Pictures class

It references:

Please Login or Register  to view this content.

Do you know what this is and how to fix it? I am fairly new to VBA.

Thanks John for the response, but I don't think this will work. I need other users to be able to insert or change the pictures in multiple sheets. I'm looking for a macro that will allow the user to browse for a picture and insert the picture or change the picture on multiple sheets. Different users that use my workbook might want a personal logo on the over 100 worksheets that produce printouts. I'm hoping they can just click a button to browse for their logo and it will be inserted on all the printout worksheets. The workbook I uploaded will insert a picture on the same sheet, but it will not do this on multiple sheets and specify the size. Any other suggestions.

I'm starting to think that I am asking the impossible. Does anyone have any suggestions? I have a workbook with over 100 pages. Each page has a logo at the top. I want to be able to quickly change the logo so different users can personalize their printouts. How can I change an image on multiple pages quickly?

Thanks snb,

This does half of what I need it to do. If this macro and the macro in the workbook I uploaded could be combined it would be perfect. Can I trouble you, or anyone, to help put them together? This is quite a bit above my VB knowledge and I would be very grateful.

The workbook I uploaded contains a macro I found that opens a window to browse for an image. The image selected is placed into a specific cell. This is great if it could do the same to several pages in the workbook, but not all of them. The part I'm not sure of is the removal of the previous image. The sheets that generate reports already have an image in them and I want the macro to remove the image and replace it with the new one.

I hope I am not pushing my luck, but I am very grateful for any help.