I need some help with a VBA macro to handle dead hyperlinks.

I want to handle the case where a user clicks on a hyperlink in Excel,
and the link is dead. (The intent is to edit the link address and try
again.)

Have tried a macro that is triggered by the
'worksheet_followhyperlink' event, and uses 'on error goto' to access
the code. But it doesn't work; it just shows a message that the
destination file cannot be opened.

Not keen to create a button for each hyperlink as there are hundreds.

Anybody got any suggestions?

Thanks

James