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.
Bookmarks