VBA Macro to create internal hyperlink

[Shiremaid]

I have a workbook with a template page that gets copied for each new country we add to a project.
There are hyperlinks that lead to places within the page (go to bottom, go to top).
I successfully created a macro to copy the template page and add it to the reports, but users still have to manually redirect the hyperlinks to the new page instead of them trying to take you back to the template page. Is there any way to use VBA to redirect the hyperlinks or is there a better way to let users move around within a worksheet?

 

[Worf]

See if this example helps:

Sub HL_Example()
Dim ws As Worksheet, h As Hyperlink
Set ws = ActiveSheet
[d75].Activate
ws.Hyperlinks.Add Selection, "", "Sheet1!C8", "Tip", "MyName"   ' new link
ws.Hyperlinks(2).Follow False, True                             ' follow link
For i = 1 To ws.Hyperlinks.count                                ' display properties
    Set h = ws.Hyperlinks(i)
    MsgBox h.SubAddress & vbLf & h.Name & vbLf & h.Range.Address
Next
ws.Hyperlinks("MyName").SubAddress = "Shops!D4"                 ' change existing link
End Sub