kualjo
12-28-2015, 10:55 AM
I have the following code in a worksheet (not a module).
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
If Target.Range.Address = "E11" Then
frmWIP.Show
End If
End Sub
I want to click the hyperlink in cell E11 of the worksheet and have it bring up userform frmWIP. When I click the hyperlink, nothing happens. The code is actually borrowed and edited for my worksheet, so I'm not sure what I'm missing or doing wrong.
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
If Target.Range.Address = "E11" Then
frmWIP.Show
End If
End Sub
I want to click the hyperlink in cell E11 of the worksheet and have it bring up userform frmWIP. When I click the hyperlink, nothing happens. The code is actually borrowed and edited for my worksheet, so I'm not sure what I'm missing or doing wrong.