How can I get this to work:
I have two kinds of hyperlinks on a sheet and I need one kind to just follow the link, but the second kind should execute a macro. The second kind of link only has a number format of "m/d/yyyy h:mm", and is only in Column A. I got stuck by the number format:
I have two kinds of hyperlinks on a sheet and I need one kind to just follow the link, but the second kind should execute a macro. The second kind of link only has a number format of "m/d/yyyy h:mm", and is only in Column A. I got stuck by the number format:
Code:
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
If Target.NumberFormat = "m/d/yyyy h:mm" Then
MsgBox ActiveCell.Value
End If
End Sub