Refreshing links to images excel vba

Hi,
I am using the following code to insert images into my excel sheet. The code works fine for inserting the images, but every now and then excel will say "This image cannot currently be displayed". Sometimes this is because we have moved the file to a shared folder and it has lost track of the images, but other times it just does it randomly. For example, this morning I had 1/33 of the images say it cannot be displayed, but I had not even moved it. I simply pressed delete and then undo and it came back, so I guess it is failing to refresh the links to the images at times, and on deletion and undoing it somehow refreshed the link maybe? I was wondering if anyone could suggest a way to refresh all links to images to avoid these two problems from happening, thanks.

Please Login or Register  to view this content.

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)