A SheetProtection object contains sheet level protection properties.
public sealed class SheetProtection
Public NotInheritable Class SheetProtection
//--- Open existing spreadsheet
ExcelApplication xla = new ExcelApplication();
Workbook wb = xla.Open(@"C:\MySpreadsheet.xls");
//--- Get SheetProtection
SheetProtection protection = wb[0].SheetProtection;
//--- Set Properties
protection.AllowFormatCells = true;
protection.AllowSort = false;
'--- Open existing spreadsheet
Dim xla As New ExcelApplication()
Dim wb As Workbook = xla.Open("C:\MySpreadsheet")
'--- Get SheetProtection
Dim protection As SheetProtection = wb(0).SheetProtection
'--- Set Properties
protection.AllowFormatCells = true;
protection.AllowSort = false;