SheetProtectionValue {Microsoft.VisualBasic.MIME.Office.Excel.XLSX.Writer}

.NET clr documentation

SheetProtectionValue

Description

Enum to define the possible protection types when protecting a worksheet

Declare

            
# namespace Microsoft.VisualBasic.MIME.Office.Excel.XLSX.Writer
export class SheetProtectionValue extends Enum {
   # If selected, the user can edit objects if the worksheets is protected
   objects: SheetProtectionValue = 0;

   # If selected, the user can edit scenarios if the worksheets is protected
   scenarios: SheetProtectionValue = 1;

   # If selected, the user can format cells if the worksheets is protected
   formatCells: SheetProtectionValue = 2;

   # If selected, the user can format columns if the worksheets is protected
   formatColumns: SheetProtectionValue = 3;

   # If selected, the user can format rows if the worksheets is protected
   formatRows: SheetProtectionValue = 4;

   # If selected, the user can insert columns if the worksheets is protected
   insertColumns: SheetProtectionValue = 5;

   # If selected, the user can insert rows if the worksheets is protected
   insertRows: SheetProtectionValue = 6;

   # If selected, the user can insert hyper links if the worksheets is protected
   insertHyperlinks: SheetProtectionValue = 7;

   # If selected, the user can delete columns if the worksheets is protected
   deleteColumns: SheetProtectionValue = 8;

   # If selected, the user can delete rows if the worksheets is protected
   deleteRows: SheetProtectionValue = 9;

   # If selected, the user can select locked cells if the worksheets is protected
   selectLockedCells: SheetProtectionValue = 10;

   # If selected, the user can sort cells if the worksheets is protected
   sort: SheetProtectionValue = 11;

   # If selected, the user can use auto filters if the worksheets is protected
   autoFilter: SheetProtectionValue = 12;

   # If selected, the user can use pivot tables if the worksheets is protected
   pivotTables: SheetProtectionValue = 13;

   # If selected, the user can select unlocked cells if the worksheets is protected
   selectUnlockedCells: SheetProtectionValue = 14;

}

        

.NET clr type reference tree

1. this class extends from Enum class: Enum
2. use by field member objects: SheetProtectionValue
3. use by field member scenarios: SheetProtectionValue
4. use by field member formatCells: SheetProtectionValue
5. use by field member formatColumns: SheetProtectionValue
6. use by field member formatRows: SheetProtectionValue
7. use by field member insertColumns: SheetProtectionValue
8. use by field member insertRows: SheetProtectionValue
9. use by field member insertHyperlinks: SheetProtectionValue
10. use by field member deleteColumns: SheetProtectionValue
11. use by field member deleteRows: SheetProtectionValue
12. use by field member selectLockedCells: SheetProtectionValue
13. use by field member sort: SheetProtectionValue
14. use by field member autoFilter: SheetProtectionValue
15. use by field member pivotTables: SheetProtectionValue
16. use by field member selectUnlockedCells: SheetProtectionValue

---