You need to make sure the cells containing the hyperlink are not locked.
FormatCellsProtectionuncheck "Locked".

NickHK

"Matthew Balch" wrote in message
...
Another question:-

I have used the protection function on a worksheet that contains
hyperlinks.

How do I still make these hyperlinks active / useable when the protection
is
on?

Cheers
Matthew Balch