VBA for Hyperlink Click (Experts only)

[tajulit]

I use this VBA code for clicking hyperlink. I am facing a problem, it click so quick. As a result Serial of link not match with browser Tab. For example, in excel which URL is 5 no serial, This link I found in 2 no tab or 7 no Tab etc.... It is very important maintain serial for me.
Now VBA click hyperlink 10 times continuously & very quickly. I want it click first one & wait until Link goes to Browser tab.

Sub ClickHyperlink()
'
' Click website link
'

    Dim i As Long

    For i = ActiveCell.Row To ActiveCell.Row + 9
        With Cells(i, ActiveCell.Column)
            If .Value <> "" Then
                If Not .Hyperlinks.Count Then .Parent.Hyperlinks.Add .Cells, "http:\\" & .Text
                .Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
            End If
        End With
    Next
    ActiveCell.Offset(0, 1).Select

End Sub

Moderator's note: Please use CODE tags for code, not QUOTE tags.