I'm busy working on a large spreadsheet and want to create a "menu" type screen where users can navigate to the sheet they require. Easy so far...

But the problem comes when I protect the sheet. I don't seem to be able to follow any of the hyperlinks. I know I have "Select locked cells" and "Select unlocked cells" unticked as I dont want the user to be able to select cells, just a hyperlink.

Any idea how I can get my hyperlinks to work?