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

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?

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?

The hyperlink is similar to a click event. If you don't click it, it does
nothing. If you do click it, it does something pre-determined by the code
attached to the link. You would have to change the code and to do that you
would have to know where the code resides. I suppose the short answer is no.
But maybe there is someone out there smater than me who can offer some
advice.

" 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?

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?