How to lock cells in excel

Question

I export to excel in a protected or using a password manner and there is a chance to unprotect the sheet. I want that, there to be no option to edit after exporting the excel to vb.net.

Answer 1

To make a column non-editable:

1. Select the whole worksheet, Right Click->Format Cells->Protection, and uncheck the "Locked" check box.

2. Select the column you want to protect, right Click-> Format Cells->Protection, and select the "Locked" check box.

3. Review tab->Protect Sheet, select the "Protect worksheet and contents of locked cells" check box and protect the sheet using a password.