I would like to create a macro that will insert a manually selected image from specific directory using Excell 2002. In other words I would like to be able to execute a macro that will take me to a predetermined directory and will pause for manual selection of an image file. Using the "Record New Macro" function It is easy to set up a macro that will insert the same image over and over again.

ActiveSheet.Pictures.Insert("\\Fileserver\otprints\ADV03(LFM-0900,C).jpg"). _
Select
End Sub

I'm sure what I am trying to do is more complicated then the simple macro above.

Can anyone help me out with this?

Thank You,

Paul