Hi All,
I have a strange problem that's only just started occurring - I have a number of hyperlinks to a checks page in my model - worksheet called 'Integrity' and reference A1. The hyperlink to the integrity page is in cell A1 of every other worksheet in the workbook.
All the hyperlinks appear to be set up correctly; however, when I click on them they take me to a different range on the last worksheet of the workbook not named 'Integrity'. If i add another sheet i.e. after the current last workbook, it then starts linking to that page. If I move the 'Integrity' worksheet to the last in the workbook, it will still link to the last sheet that isn't named 'Integrity'.
Has anyone come across this before, and how I might fix this?
Thanks in advance,
Doodle
I have a strange problem that's only just started occurring - I have a number of hyperlinks to a checks page in my model - worksheet called 'Integrity' and reference A1. The hyperlink to the integrity page is in cell A1 of every other worksheet in the workbook.
All the hyperlinks appear to be set up correctly; however, when I click on them they take me to a different range on the last worksheet of the workbook not named 'Integrity'. If i add another sheet i.e. after the current last workbook, it then starts linking to that page. If I move the 'Integrity' worksheet to the last in the workbook, it will still link to the last sheet that isn't named 'Integrity'.
Has anyone come across this before, and how I might fix this?
Thanks in advance,
Doodle