I have no experience using VBA, but I am comfortable with javascript and open to learning. Just wanted to check that there was not already an easy solution to this that I am missing, before I dedicate time to learning something big.

Is any good way to trigger an alert window (i.e. a user prompt or popup) when someone clicks a particular hyper link. So that, for example, the hyperlink could say: "The referenced document has been attached to this memo as appendix 1, to continue to the original online version please please click "Continue" otherwise x out of this box." And then have the user be redirect (as a normal hyperlink would be) to the page, if they click continue.

I assume you are talking about a hyperlink in an excel document. You can make a macro in vba and put the name of the macro in the hyperlink where the link address would normally go. The macro will be fired when you hover the mouse pointer over the link.
=IFERROR(HYPERLINK(MyMouseOverEvent(),"Click here"), "Click here")

I don't know why you'd assume a question about intercepting hyperlinks via VBA in a Word VBA forum on a board that also has an Excel Programming forum has anything to do with Excel or that an Excel formula would be appropriate...

As it is, Word has no hyperlink event to trap. Consequently, anything that might be done in that regard (if possible) would probably have to be done through the Windows API.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Haha... My bad... I came here via a search and didn't notice which forum it was. Its not so clear in this app. Thanks for the heads-up.