Hello, any guidance with the following would be appreciated.
I have a Worksheet which has two Hyperlinks per each row. The first Hyperlink in Column A has a HTTP link to a Web Page, where it.
https://w3.abc.com/systema/legacy/protected/AB/mainsheet/e/ID000980/mainaction.wss
The 2nd Hyperlink in Column B invokes Macro FindOutMore and passes contents of Column C for the row in which the hyperlink is selected.
ActiveSheet.Hyperlinks.Add Anchor:=ActiveSheet.Cells(R, 2), _
Address:="", _
SubAddress:=ActiveSheet.Name & "!A1", _
TextToDisplay:="Quick View", ScreenTip:="Summary of the data"
To invoke the macro, I have the following code in "View Code" of the worksheet
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Call FindOutMore(Target.Range.Offset(0, 1).Value)
End Sub
The problem is that when I click either hyperlink, they both invoke macro FindOutMore. I only want this to happen for the 2nd Hyperlink in Column B and not the first Hyperlink in Column A which launches a Web Page. Any suggestions on how to do this ?
I have a Worksheet which has two Hyperlinks per each row. The first Hyperlink in Column A has a HTTP link to a Web Page, where it.
https://w3.abc.com/systema/legacy/protected/AB/mainsheet/e/ID000980/mainaction.wss
The 2nd Hyperlink in Column B invokes Macro FindOutMore and passes contents of Column C for the row in which the hyperlink is selected.
ActiveSheet.Hyperlinks.Add Anchor:=ActiveSheet.Cells(R, 2), _
Address:="", _
SubAddress:=ActiveSheet.Name & "!A1", _
TextToDisplay:="Quick View", ScreenTip:="Summary of the data"
To invoke the macro, I have the following code in "View Code" of the worksheet
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Call FindOutMore(Target.Range.Offset(0, 1).Value)
End Sub
The problem is that when I click either hyperlink, they both invoke macro FindOutMore. I only want this to happen for the 2nd Hyperlink in Column B and not the first Hyperlink in Column A which launches a Web Page. Any suggestions on how to do this ?