I am trying to set the protection for a worksheet so that the cells are not editable, but then allow editing of certain cells. This is to help the user when working with the exported excel file.
I guess this means protection at the cell level? I can't seem to figure it out...
If the sheet is protected and you want to make some cells editable, you can set the cells' CellFormat.Locked properties to False.
I am not able to protect the worksheet. Can you please post the snippet.
Thanks,
Mani.