I'm trying to setup "non modifiable" column headers so that users can cut/paste or edit to provide values on worksheets. I have successfully set the first row to Frozen, but I also want to protect the cells that contains the column headers so that users cannot modify or delete the cells, but the following code does not work.
worksheet = project.MyWorkbook.Worksheets.Add("historical_injectivity.txt");worksheet.Protected = true;for (int i = 0; i < 2.Count; i++) { worksheet.Rows[0].Cells[i].CellFormat.Locked = ExcelDefaultableBoolean.True; }
Can you offer any help?
Hello,
I am just checking if you require any further assistance on the matter.