Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Hyperlink verification message

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlink Error Message tigermoth Excel Discussion (Misc queries) 1 March 6th 09 05:51 AM
hyperlink a cell to an email message vlad Excel Programming 0 June 18th 05 02:28 PM
Remove Hyperlink Path Message Phil Hageman[_4_] Excel Programming 0 June 6th 05 01:38 PM
message 'hyperlink can be harmful warning..etc...' ljmccrary Excel Discussion (Misc queries) 2 March 24th 05 07:29 PM
hyperlink function verification Mike Dickey Excel Programming 2 February 18th 04 09:51 PM


All times are GMT +1. The time now is 08:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"