gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,341
- Office Version
- 365
- Platform
- Windows
I need to enter a condition -
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
If Range("Z84") > 1 And
Range("D10") = "" Then
UserForm69.Show
End If
- to meet before the hyperlink takes you to its destination. The problem is the this is a "FollowHyperlink" action. It takes me to the next page and then displays the Userform. Basically I dont want the user to be able to leave the page via hyperlink if the two conditions above are not met.
HELP!!!!!!!!!!!!!!!!
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
If Range("Z84") > 1 And
Range("D10") = "" Then
UserForm69.Show
End If
- to meet before the hyperlink takes you to its destination. The problem is the this is a "FollowHyperlink" action. It takes me to the next page and then displays the Userform. Basically I dont want the user to be able to leave the page via hyperlink if the two conditions above are not met.
HELP!!!!!!!!!!!!!!!!