Home » Forums » Open Source Learning Center » Question and Answer

Editable areas

Submitted by batya on 8 September, 2014 - 08:40

Hi dear members.
I want to make editable only yellow marked areas. Can anyone help me with this?
Thanks in advance!

AttachmentSize
Editable areas.xlsx14.24 KB
‹ Extract Data from large file Please Help modify macro to include additional columns ›
»

Hi Batya Highlight all yellow

Submitted by mec1981 on 17 September, 2014 - 04:06.

Hi Batya

Highlight all yellow cells, select format cells, go to protection tab and uncheck the locked box and select ok.

Go to file ? Info ? protect workbook ? Protect Current sheet. insert a password of your choice.

Now all cells apart from those you've unlocked cannot be edited without the password to unprotect.

Regards
Mark

»