Protect Worksheet
Protect current worksheet from changes
Input
- Sheet Name: The Excel sheet to be processed (If no sheet name is entered, the last used Excel sheet is taken by default)
- Type:
System.String
- Type:
- Sheet Password: The password to protect the sheet
- Type:
System.String - Required
- Type:
Misc
- Drawing Objects: Protects the drawing objects in the worksheet.
- Type:
System.Boolean
- Type:
- Contents: Protects the contents of the worksheet.
- Type:
System.Boolean
- Type:
- Scenarios: Scenarios to be protected.
- Type:
System.Boolean
- Type:
- Only User Interface: If only the user interface needs to be protected, it should be checked.
- Type:
System.Boolean
- Type:
- Allow Cell Editing: If cell editing should be prevented, it should not be checked.
- Type:
System.Boolean
- Type:
- Allow Column Editing: If column editing should be prevented, it should not be checked.
- Type:
System.Boolean
- Type:
- Allow Row Editing: If row editing should be prevented, it should not be checked.
- Type:
System.Boolean
- Type:
- Allow Inserting Columns: If inserting columns should be prevented, it should not be checked.
- Type:
System.Boolean
- Type:
- Allow Inserting Rows: If inserting rows should be prevented, it should not be checked.
- Type:
System.Boolean
- Type:
- Allow Inserting Hyperlinks: If inserting hyperlinks should be prevented, it should not be checked.
- Type:
System.Boolean
- Type:
- Allow Deleting Columns: If column deletion should be prevented, it should not be checked.
- Type:
System.Boolean
- Type:
- Allow Deleting Rows: If row deletion should be prevented, it should not be checked.
- Type:
System.Boolean
- Type:
- Allow Sorting: If sorting should be prevented, it should not be checked.
- Type:
System.Boolean
- Type:
- Allow Filtering: If filtering should be prevented, it should not be checked.
- Type:
System.Boolean
- Type:
- Allow Using PivotTables: If using PivotTables should be prevented, it should not be checked.
- Type:
System.Boolean
- Type:
Details
- This activity can only be used within the Use Excel File activity. Excel application must be installed on the machine where the process will run.