V
veggies27
I am trying to automatically activate a hyperlink if a certain cell has a
value in it. Is there a way this is possible?
value in it. Is there a way this is possible?
Mike H said:Hi,
No problem we'll get there. using X in your code makes X a variable and not
the letter X. To make it the letter X put it in quotes like below. Now you
'may' encounter another problem because it becomes case sensitive so note how
i've included an UCASE statement so if you now enter x or X it works
Private Sub Worksheet_Change(ByVal Target As Range)
If UCase(Range("E5").Value) = "X" Then
Range("B5").Hyperlinks(1).Follow
End If
End Sub
Mike