I would like to run a macro that displays a customised message when the
file
attached to the hyperlink is located in a folder that is not accessible

to the user, or if the file does not exist.

I have attempted using the sheet event Worksheet_FollowHyperlink(ByVal
Target As Hyperlink) to work in parallel and verify the link but the
macro is not activated if the reference is missing. Instead only an
Excel warning appears.


Can anybody please let me know which method or VBA code will do this.


Many thanks