Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sheet protection with links
Dear all,
I have a sheet that has links to another file. I would like to protect the cells with the links so that the links cannot be deleted (i.e. the formula/format of the link) and replaced by values, but would like to allow the link to be changed to the corresponding file. Is there any way to do this? Thank you for your help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sheet protection with links
Hi,
before protecting the sheet the cell has to be protected, on the cell where the hiperlink is, right click on the mouse, cell format, protection, check the locked box, then protect the sheet "sthart" wrote: Dear all, I have a sheet that has links to another file. I would like to protect the cells with the links so that the links cannot be deleted (i.e. the formula/format of the link) and replaced by values, but would like to allow the link to be changed to the corresponding file. Is there any way to do this? Thank you for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
Worksheet Protection & Edit Links | Excel Discussion (Misc queries) | |||
VBA to stop XL from adding the Path Sring to Sheet-to-Sheet Links | Excel Discussion (Misc queries) | |||
Cell protection and changing links | Excel Discussion (Misc queries) |