Hyperlink not working

[Ravi181229]

Sub Button5_Click()
Worksheets("sheet1").Range("J3:P17").Value = Worksheets("sheet3").Range("A2:F16").Value
End Sub

Hi All,

I am facing some issues with the above formula. I have created a button and added above mention code to it. It shows all the values within Range A2:F16 on sheet 3 in sheet 1 range J3:P17. Range A2:F16 on sheet 3 has some hyperlinks, however these hyperlinks are not working/activated on Sheet 1. Is there anyway these links can be activated.


Regards
Ravi