Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Handling Dead Hyperlinks
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How Can I remove Dead Links ??? | Links and Linking in Excel | |||
Dead spot in worksheet | Excel Discussion (Misc queries) | |||
Brain Dead | Excel Discussion (Misc queries) | |||
Removing dead Link | New Users to Excel | |||
Brain Dead: Need help with ???? | Excel Worksheet Functions |