Customize Hyperlink Window Message I have a macro that creates automatic hyperli

Question

Customize Hyperlink Window Message

I have a macro that creates automatic hyperlinks. When the file is created and located under the directory that target this hyperlink the hyperlink open the file. However, when the file has not been created and placed it under this directory obviously the hyperlink does not work and show me the following windows message::

I wonder if there is a way to customize this window message to have "The file has not been created yet. Please contact the project owner" instead.

Could you please let me know if is possible..

Thanks in advance!!

Explanation / Answer

Hi..

I don't think there is such a way...

There is a FollowHyperlink event for a Worksheet, but the hyperlink action happens before the event is triggered, not afterwards, and indeed the event is not even called if the target file does not exist and the message "cannot open the specified file" has been shown...

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.