If statement when Run-Time Error Code 490 is displayed onscreen

[sparx]

Hi all, I have tried to find without luck some help regards the onscreen message "Cannot open the specified file" which is error code 490.

In my VBA projects I normally use the "On Error GoTo ErrHandler:" line and then write in an If statement for a given error code.

My worksheet cell's contain hyperlinks, the formula's within the cell's are written correctly and point to the correct file path etc but if the actual file does not exist, the onscreen message is shown "Cannot open the specified file", this is where I want to change what happens.

Is there a way via VBA to disable the message from being shown and at the same time run some code via the If statement.

I know its not really an error as such but wanted to see if I could use the response to trigger something different.

Thank you to anyone who could help.

[Norie]

You could 'intercept' the hyperlink using the sheet's FollowHyperlink event which looks like this.

Please Login or Register  to view this content.

Target represents the hyperlink that's been clicked and you could use code in the event to check if it's valid/if the file exists.

If there is a problem with the hyperlink you should be able to handle it yourself.

[sparx]

Hello Norie, I tried using your method but nothing happens.

Please Login or Register  to view this content.

Can I be missing something really simple?