Escanaba
asked on
Excel 2007 VBA to Update Hyperlinks
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!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you