Copying worksheets and hyperlinks VBA

[DrH100]

I have the following code

Public Sub Copyworksheet()
Dim wb As Workbook
Set wb = Workbooks.Open("\\My file path in here", UpdateLinks:=True)
wb.Worksheets("People").Copy before:=ThisWorkbook.Worksheets(3)
wb.Close savechanges:=True
Set wb = Nothing
End Sub

Which opens the specified workbook. Copies the worksheet called "People" and puts the copy in my original workbook.

That all works fine apart from any hyperlinks that were on the "people" worksheet no longer work.

If I hover the mouse over the hyperlink it shows file:///\\ then the file path and gives me canno ope the specified file.

Is there anything that can be done to make sure the hyperlinks work when I copy them across with the worksheet?

Any help appreciated

 

[142353]

DrH100, I am having the same issue as you did here, but I did not see any answers to your problem. Was it resolved?