Hello,
I notice that everytime I bulk tried to find & replace the hyperlink inside a excel cell, once hover over or clicked on the link it will show the old original outdated link, I was wondering how can I have the new one to show everytime.
Below is a example of what I'm referring to.
EXCEL.jpg
Links are created in more than one way and Excel holds the values differently
- the VBA below corrects the "visible" value for both "embedded" links and links created by "formula"
This may be overkill for what you need but it should work.
The procedure FriendlyNameToEqualLink
- loops through all worksheets in the workbook
- identifies those links where visible text differs to link value
- overwrites the "visible" text with correct link value
- creates a worksheet listing those cells with values that differed
If you only want this to run for ONE sheet, amend this line to include the correct name for your worksheet:
If ws.Name = "SomeLinks" Then Call CheckLinks(ws, 0)
If there are multiple sheets and all are to be checked, amend to:
Call CheckLinks(ws, 0)
Paste everything below into a general module:
Please Login or Register to view this content.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks