kualjo
12-29-2015, 07:44 AM
I have a need to insert several hyperlinks into a worksheet, each that would run different macros. There is currently a single hyperlink running one macro, but I need at least one more. The code I have is...
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
frmWIP.Show
End Sub
...which runs my userform. I'm now building a second userform and need a second hyperlink to run it. I've tried referencing the hyperlink's cell, but then nothing happens at all.
I'm kind of stuck. How can I make this work?
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
frmWIP.Show
End Sub
...which runs my userform. I'm now building a second userform and need a second hyperlink to run it. I've tried referencing the hyperlink's cell, but then nothing happens at all.
I'm kind of stuck. How can I make this work?