Removing path of inserted images

[gunter511]

I managed to insert many images via url links into a column of an excel worksheet using VBA (cut & pasted from a script I found online). Sometimes this message appears: "The linked image cannot be displayed. The file may have moved etc. etc." I assume this means the path is still there. How would I go about removing the paths of all the images so they always display correctly?
Many thanks!
Gunter

 

[yky]

Check to see if the links are still valid. I think the images are no longer there.

 

[gunter511]

Check to see if the links are still valid. I think the images are no longer there.

Thank you for your reply.

THe problem is that sometimes the images appear and sometimes they don't. e.g. if you scroll up or down the page, an image may appear
or not. I removed the column which had the original url to download the images but I don't know how to remove the links. When I click
on a cell with an image, it does not appear to have a hyperlink but the image may still be visible.

Would you be able to help in explaining if, somehow, the path is still embedded, how I would remove it?
The file was originally a macros enabled one but it is now saved as an .xlsx one.

Many thanks!!

 

[yky]

Would you post the script? Maybe it can be improved.