Hyperlink to hidden cells

Question

Hi everyone.

I have followed these steps carefully: https://www.extendoffice.com/documents/excel/4188-how-to-follow-hyperlink-to-hidden-sheet-in-excel.html

But I have tried and tried to get the sheets open and close. Its no different from old Excel - apart from an Index sheet! Any ideas would be very appreciated. I have copied and pasted the codes etc int the Index sheet....still no joy.

Thank you.

David