How to use hyperlinks on a protected sheet properly?

[Seanis00]

Hi Guys,

I've attached a test spreadsheet below to show you what I'm trying to do because I can't figure it out.

I have 2 workbooks (one where every sheet is available and another where some aren't, but I've left the sheets there to show people that they Can purchase those sheets as well).

On these workbook where they aren't available, I've put some text on there to pretty much say it's unavailable but you can purchase them from the following URL and then put the URL below with a hyperlink.

I like to protect every worksheet with a password as there are a lot of formulas in the other pages and I think it looks more professional when cells can't be clicked into if it's data that just needs to be read.

In this case though I would like the hyperlink available to be clicked on.

If I protect the whole sheet and say that cells can't be clicked on at all (as shown in the attachment but without a password) then the Hyperlink can't be clicked...

If I unprotect just that one cell, then when you view it after protecting it automatically highlights that cell, which I reluctantly will put up with, but there's a problem created where it will take you to that link if you click on the worksheet literally anywhere... some people click as a bad habit while reading and this would take them away from the sheet before reading it all, so is there an easy way to allow the hyperlink to work but only when that cell is clicked?

Cheers,

Sean

[teylyn]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.