Workbook protection

Hi Hatice,

Thank you for your question and welcome to the forum.

Select the cells that need to be overwritten and right click over one of the selected cells. Choose Format Cells and then select the Protection tab. Finally, untick the Locked checkbox.

Now you are ready to protect the sheet with a password. Go to the Review Tab on the ribbon and click Protect Sheet. Type a password in and re-enter to confirm.

All the cells on that sheet will be locked apart from the ones you unlocked.

I hopw this answers your question.

Regards

Simon