Excel 2010 "vlookup pictures vba" links image instead of saving it as an image

Guys the code below does exactly what I want in excel 2007 but not quiet in excel 2010. I do not know what changed but it links the picture I am looking up instead of saving it as a picture. What should I do? I searched and searched on the net but couldn't find a working solution for myself. What do you suggest to save the pictures as pictures not links to the path? I want to be able to send this excel file via e-mail to my colleagues and want them to see everything they need on the excel sheet not linked to certain folders.

Please Login or Register  to view this content.

Thanks in advance guys.