Hi all,
I have an excel sheet with several incorrect hyperlink.
I would like to create a macro that:
- You press hyperlink on cell
- The address is passed to a macro
- The macro returns the correct address
- and jpg file is opened with correct link
example
hyperlink to "c:\OldFolder\image.jpg" ===> OldFolder doesn't exist
and macro return "c:\NewFolder\image.jpg" ===> that exists
The links are not sorted, they are scattered everywhere
How can I do?
thank you very much
for any suggestions
K.
Bookmarks