Ken: This should work. To my knowledge only Word has problems with
hyperlinks in protected documents, not Excel. What version are you running?
Have you tried Ctrl+Click to follow the hyperlink? What method are you using
to create the hyperlink?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


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

I'd like to think that my problem is a simple one, however I may
just be attempting something Excel isn't designed for.

I have a single worksheet that I wish to use as a menu into
various Excel & Word documents. Quite simple to do, with hyperlinks to
my local files but I don't wish to allow the "Human Factor" too much
leeway. (My clients' skill levels range from network administrators &
programmers, to the painfully computer illiterate).

To prevent overwriting of my links, I'd like to protect my sheet.
While this is a simple procedure, I've found that when my sheet is
protected the links don't work.

I've tried various combinations of protection, locked & unlocked
cells and the Worksheets(1).EnableSelection property. All I've been able
to do is to either prevent the link from working, or permit full access
to the cell.

The Help files describe the properties simply enough, but I can't
seem to work out whether the cells can, in fact, allow access for use as
a link, but not allow access to amend the cell.

Can someone please clarify this for me? and perhaps offer a
direction?

Thanks for listening,
--
Ken McLennan
Qld, Australia