I have created a workbook with hyperlinks to files on a network server.
The purpose is that network users can easily find and access files.
Network security will ensure that users can only access files within
their permissions.

I would like to run a macro that displays a message when the file
attached to the hyperlink is located in a folder that is not accessible
to the user, or if th efile does not exist. The message needs to
replace the standard Excel message that appears if a hyeprlink error
occurs.

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
Wim