sheet protection with links

S

sthart

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!
 
E

Eduardo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top