Howdy
A range 1 column by about 30 rows of my workbook contains cells with text
and hyperlinks to the internet for the text. For this example's sake, I want
to entirely protect the worksheet but have users able to click the
hyperlinks.
So I unlock the range in question, protect the worksheet and check the
checkbox for 'select unlocked cells', which works fine and you can click the
hyperlinks and IE will open and browse to correct page, but if you click
anywhere else in the workbook (i.e. on locked cells) the last selected
hyperlink is then opened!!!!
How can I prevent this happening?
Thanks
Matt