This one probably seems like a stupid request, since I could just use a regular hyper-link to jump to a different part of the same sheet.

However, I'd like to lock people into certain areas of the sheet until the hyper-link is clicked. So when they enter the page the scroll area is set to A1:FP66. When the hyper-link is clicked, it would change the scroll area to A103:FP170 and take the user to that part of the worksheet. There would be a hyper-link within this range that would return them. Is this possible?

I know its possible to activate a macro using a hyper-link. Currently got this for my code but it doesn't work at all.

Private Sub Worksheet_FollowHyperlink2(ByVal Target As Hyperlink)
Dim sht As Worksheet
Set sht = ThisWorkbook.Sheets("Sheet 3")
  
    If Target.Range.Address = "'Sheet 3'!A1" Then
        sht.ScrollArea = "A1:FP66"
        Exit Sub
    End If
End Sub