View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default 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!