Hi All,
I'm really bad at VBA but managed to insert many images via url links in a column of an excel worksheet using VBA. They mostly work ok but sometimes this message appears: "The linked image cannot be displayed. The file may have moved etc. etc." (This happens specially after I have emailed the file to someone) I assume this means the path is still present in excel. How would I go about removing the paths of all the images so they always display correctly?
Thank you in advance!
I'm really bad at VBA but managed to insert many images via url links in a column of an excel worksheet using VBA. They mostly work ok but sometimes this message appears: "The linked image cannot be displayed. The file may have moved etc. etc." (This happens specially after I have emailed the file to someone) I assume this means the path is still present in excel. How would I go about removing the paths of all the images so they always display correctly?
Thank you in advance!