-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
FollowHyperlink Cancel
- Thread starter timorrill
- Start date
-
- Tags
- cancel followhyperlink
I take it you mean every time you click on e.g.
www.hotmail.com excel opens up that webpage?
Just highlight the cells the hyper links are in, right click, paste special, and paste values. It will remain www.hotmail.com but when you click on it, it's will now be normal text.
www.hotmail.com excel opens up that webpage?
Just highlight the cells the hyper links are in, right click, paste special, and paste values. It will remain www.hotmail.com but when you click on it, it's will now be normal text.
Upvote
0
No, that's not quite what I meant.
I'm using the event Worksheet_FollowHyperlink() in VBA which is triggered whenever a hyperlink is clicked on the worksheet. If certain conditions are met (cells have certain values), I want to cancel the action so that the webpage is NOT displayed. Otherwise, if the criteria are not met, the user may proceed.
I'm using the event Worksheet_FollowHyperlink() in VBA which is triggered whenever a hyperlink is clicked on the worksheet. If certain conditions are met (cells have certain values), I want to cancel the action so that the webpage is NOT displayed. Otherwise, if the criteria are not met, the user may proceed.
Upvote
0
