Protection - Hyperlinks
 

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

Protection - Hyperlinks
 

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

Protection - Hyperlinks
 

Thanks

I had done this dut didn't work. Just redid it and now working. Must have
selected the wrong cells to unlock.

*Doh*



"NickHK" wrote:

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