troubleshooting Question

Excel 2007 VBA to Update Hyperlinks

Avatar of Escanaba
EscanabaFlag for United States of America asked on
Microsoft ExcelVB Script
2 Comments1 Solution343 ViewsLast Modified:
Hello,

I have a spreadsheet which contains multiple hyperlinks in column B that are linked to various worksheets in the same workbook.  For some reason, the links are changing to the wrong worksheets constantly and require manual editing.

All of text in column B matches the name of a worksheet.  For example, in cell B2 the hyperlink text is RIA0000 and there is a worksheet also named RIA0000 that its suppose to link to.

Is it possible to run a macro that will look at each cell in column B (starting at B2), and if there is a hyperlink, automatically update it so that the page source matches the name in the cell?  Looking at the previous example, the text in cell B2 is a hyperlink named RIA0000 but due to this issue the hyperlink is going to an incorrect worksheet.  Can the macro look at cell B2, see that its named RIA0000 and then change the link source so that when clicked it will take the user to worksheet RIA0000?

Thanks!
ASKER CERTIFIED SOLUTION
Swapnil Nirmal
Manager, Audit Analytics

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros