Hyper Link

[ColeGwoz]

Is there anyway to link this hyperlink to the sheet created in the code?? Thanks.

If Me.cbStores.Value = "Northern / Northmart" Then

Dim sh As Worksheet
Set sh = Sheets.Add
sh.Name = AddEmployeeUF.txtFirstname.Text + AddEmployeeUF.txtMiddleinitial.Text + AddEmployeeUF.txtLastname.Text + "Template"
ws.Hyperlinks.Add Anchor:=ws.Range("F" & LastRow), Address:="", SubAddress:="", TextToDisplay:="View"

Else 'do nothing
End If

 

[ColeGwoz]

This did the trick:

SubAddress:=sh.Name & "!A1"