What you could do is set it up so that a condition must be met before the
Hyperlink is displayed. You can use:
If (condidtion is true) then
MySheet.Range(somewhere) = "Hyperlink"
Else
(do something else)
End If


" wrote:

Sorry, no I mean when the user clicks on it, to conditionally cancel
the loading of the URL.

JLGWhiz wrote:
One way is to delete it. You can also right click on it and then click
"Remove Hyperlink".

" wrote:

Is there any way to cancel the clicking of a hyperlink?