hyperlink
 

I have some cell that are hyperlinked to another sheet. When the sheet that
contains the hyperlinked cells is protected the hyperlink doesn't work. I
want to leave the hyperlinked cell locked so that they can't be changed. How
do I do this?
Thanks

hyperlink
 

In Excel 2003:
Insert hyperlink in cell
From Menu select 'Format' 'Cells' then protection tab tick 'Locked' - OK
From Menu select 'Tools' 'Protection' 'Protect Sheet' tick 'Select locked
Cells' & 'Insert Hyperlink' + any others of your choice - OK
You can then select the cell with the hyperlink but not delete the contents
Hope this helps

"ranswert" wrote:

I have some cell that are hyperlinked to another sheet. When the sheet that
contains the hyperlinked cells is protected the hyperlink doesn't work. I
want to leave the hyperlinked cell locked so that they can't be changed. How
do I do this?
Thanks

hyperlink
 

Thanks I'll give that a try

"Ron@Buy" wrote:

In Excel 2003:
Insert hyperlink in cell
From Menu select 'Format' 'Cells' then protection tab tick 'Locked' - OK
From Menu select 'Tools' 'Protection' 'Protect Sheet' tick 'Select locked
Cells' & 'Insert Hyperlink' + any others of your choice - OK
You can then select the cell with the hyperlink but not delete the contents
Hope this helps

"ranswert" wrote:

I have some cell that are hyperlinked to another sheet. When the sheet that
contains the hyperlinked cells is protected the hyperlink doesn't work. I
want to leave the hyperlinked cell locked so that they can't be changed. How
do I do this?
Thanks