change sheet name maintain Hyperlinks

[tmadaras]

I have multiple sheets with hyperlinks to other sheets in the same workbook - I want to change the names of the sheets but neetdit to automatically change the hyperlinks and not break them. When I change sheet2 name to something else the Hyperlinks from the other pages no longer work. I want to change the name and update all hyperlinks on all other pages automatically.

 

[XLfriend777]

Hi tmadaras - Welcome to the forum. You might try creating a Named Location using the Name Manager and then referencing your hyperlinks to that Named Location. When the tab names are changed, the Name Manager takes care of renaming the hyperlink. Hope this helps you get started.