Inserting pictures into multiple sheets

Hi everybody.

I tried for a long time, but I couldn't sort out how to insert pictures to multiple sheets on the same workbook, by pressing the button on the first sheet.

I want to press the button on the first sheet and see the pictures (from a folder on my computer) show up on the other sheets. Is it possible on Excel 2010?

Thanks in advance!

Try this macro

Sub Test()
Const MyPath = "C:\Documents and Settings\Me\My Documents\My Pictures\"

MyFileName = Dir(MyPath & "*.jpg")
Do While MyFileName <> ""
    Sheets.Add After:=Sheets(Sheets.Count)
    ActiveSheet.Pictures.Insert(MyPath & MyFileName).Select
    MyFileName = Dir()
Loop
End Sub

Open up the VBA editor by hitting ALT F11

Insert a new module by hitting Insert - Module

Paste the macro into the empty sheet

Hit ALT F11 to get back to the worksheet.

Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007.

Thank you, mrice...

The exact thing I need is, when I click the button (created by me) on the 1st sheet, the macro will insert a picture into Sheet2 or Sheet3, it doesn't matter which sheet it inserts. And I want to stay on the first sheet, instead of switching to the sheet, which the picture shows up.

Thank you for your efforts.