hyperlink "reference not valid" when sheet name change

[SSPoulin23]

Hi All,

I have a workbook that will have a sheet that is a template for contractor information. When a new contractor is entered, I have a blank template sheet (that is called TempMain for now). I have a VBA directive to rename the sheet automatically based on an entry in cell Q14. However, when the sheet is renamed, it makes all of the hyperlinks within the sheet invalid (message saying "Reference not valid" when I click on a link after the name change). If I change the sheet name back, the links work again.

How can I make the hyperlinks dynamic with regard to the name changes and not just dynamic with regard to manipulating data within the sheet itself (like adding/deleting rows, 'cos I've found that answer already).

THANK YOU!

 

[SSPoulin23]

... I've seen some similar threads with no replies - REALLY hoping someone has a solution to this issue

 

[SSPoulin23]

... or maybe someone can tell me if I'm just spinnin my wheels because it's impossible?

 

[SSPoulin23]

well, just so everyone knows, if you Define the name of the cell you want to go to and then say "go to this place in the document" instead of saying "go to this cell", it works. no matter if you rename the sheet or if you make a copy and want the cells to reference the same place in the copy and not the original sheet.

HURRAY!!!