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 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

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 verification message WimR Excel Programming 0 March 14th 06 10:36 PM
hyperlink a cell to an email message vlad Excel Programming 0 June 18th 05 02:28 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 11:58 AM.

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"