VBA // refresh only selected links

[DonAndress]

Hello.

I have a workbook with links to multiple network workbooks.
Because this is a workbook that many people can use, some of the links are broken (or the drive letter changes).

Now, when I know that for example all links starting with G:\TempPath\ are correct, is it possible to refresh only selected links via VBA?
I mean all those starting with G:\TempPath\ and ommit other.

 

[vicedo]

why don't you record a macro as you select the cells? Then paste the macro here for modification. That way, you will learn more