Getting Hyperlink error

[statish]

I have an excel workbook where i have 2 sheet.

1st Sheet have certain hyperlinks to sheet 2 cell as below

Sheet 1 A1 = Sheet 2 A1


Sheet 1 A2 = Sheet 2 A2

everything works fine however if I change the name of my sheet all hyperlinking stop working and start giving me error reference is not valid.

Can you please help me how i can make my hyperlink kept working even if someone change the sheet name.

And further is there any way by which we can correct all hyperlink in one go.

Please assist

 

[Misca]

The easiest (?) way to keep hyperlinks working with changing sheet names is to use named ranges instead of normal cell addresses.