Ken, why are you using that method to protect the cells? I think that's the
problem. Just use regular cell locking, and use code to protect/unprotect
the sheet itself. I think that'll resolve your issue.
http://www.officearticles.com/excel/...soft_excel.htm
If you often need to work on the workbook, you can protect/unprotect all
sheets at once using a macro like this one:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=142

*******************
~Anne Troy

www.OfficeArticles.com


"Ken McLennan" wrote in message
.. .
G'day there Anne,

Ken: This should work. To my knowledge only Word has problems with
hyperlinks in protected documents, not Excel. What version are you
running?

That's interesting. I've got an upcoming project for Word, too,
but I don't know as yet whether I'll need to work with hyperlinks there.
At least now I have a "heads up" so I'll keep your warning in mind.
Thanks for that.

FYI, I'm using Excel 2002 from Office XP. On, obviously, Windows
XP (Home version). There are no service packs installed.

Have you tried Ctrl+Click to follow the hyperlink? What method are you
using
to create the hyperlink?

I can easily follow the hyperlink by the usual "click on the
underlined text" method =). I just tried Ctrl+Click and can safely
report that absolutely zilch occurred while the sheet was protected.
When unprotected I simply made a non contiguous selection, as though
there was no link.

I find that the links work as designed/intended, but only when the
cells aren't protected. I want to protect the cell contents; but when I
tick the "locked" checkbox in the Format Cells dialogue, and protect the
sheet, then I can't select the cell containing the link & hence the link
doesn't work.

At the moment I have the cells containing links "unlocked" and
protect the content via code in the ThisWorkbook module:

With Me.Worksheets(1)
.EnableSelection = xlUnlockedCells
.Protect contents:=True
End With

This allows the links to work, but leaves the contents vulnerable
to corruption.

To protect the link I need to have the "locked" checkbox checked
and hence the cell is not selectable, therefore the link can't be used.

To answer your last question, I just use the Insert Hyperlink
dialogue from the Right Click menu.

Thanks for offering your assistance, it's much appreciated.

--
Ken McLennan
Qld, Australia