Automatically changing screentip for "each"/"every" hyperlink in worksheet?

Hi All,

The script below works by adding a hyperlink with a custom screentip on-the-fly. However, the custom screentip only displays on the 1st hyperlinked cell.

- Does anyone know how to get the "custom" screentip to show on "EACH" hyperlink being created, on-the-fly?
or if that's not possible, does anyone know how to update "EVERY" hyperlink with custom screentip on-the-fly (instead of just the 1st)

Please Login or Register  to view this content.

ps: This is using Excel 2007. Thanks so much, JMC

Solved! Thank you so much, Jason! And thank you for the quick reply too! Your suggestion worked beautifully!! -JMC

You're welcome.

In case you didn't notice, I did add an extra piece of code for you to fix the existing hyperlinks.

If you're happy that your query has been resolved could you please flag it as solved in the thread tools menu (just above post #1, on the right)