| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
| How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
| Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
| Hyperlink from one sheet to the hyperlink on another | Excel Discussion (Misc queries) | |||
| Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
Linear Mode
