ChangeLinks results in directory prompt for each link

The macro below is to update each link flagged with a "Yes".

However, running the macro resulted in getting a directory prompt for each link,
although all of the old files were in one folder and all of the new files were in their own separate folder.

Both OldLinks and NewLinks are filenames with full paths.

Do I need to change directories or something?

PHP Code: 

Sub UpdateLinks()
    Sheets("Link Summary").Select
    LinkCount = (Range(Range("A2"), Range("A9999").End(xlUp)).Rows.Count - 5) / 2
    
    Rows("1:1").Select
    Selection.Find(What:="Update?", After:=ActiveCell, LookIn:=xlValues).Activate
    Set Changes = ActiveCell.EntireColumn.SpecialCells(xlCellTypeFormulas, 23)
    Changes.Select      '''This is a single column containing a Yes/No flag
    
    For x = 1 To LinkCount
        If Changes(x) = "Yes" Then
            OldLink = Range("A" & Changes(x).Row).Value
            NewLink = Changes(x).Offset(0, 1).Value
            ActiveWorkbook.ChangeLink Name:=OldLink, NewName:=NewLink, Type:=xlExcelLinks
        End If
        Changes.Select
    Next x
    
    MsgBox "Finished!"

End Sub 


You can insert this line to break the link

Please Login or Register  to view this content.

And may add

Please Login or Register  to view this content.

Thanks AB33.
I will give it a try when I get back to that file;
is there a quick way to reset these settings to whatever they were before the macro was run?

Thanks,

Works great!

My coding may not be the shortest, but it is nice to know that
1) it works, and
2) it is getting better.

Thanks AB!

Anil