Stop a sheet being edited by accident. This is not security: an Excel sheet password is trivially removed, so use it to protect a report from mistakes rather than to keep a secret
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | Not set | |
Sheet Name sheetName | string | Optional | Not set | Leave empty for the first sheet |
Action action | enum | Optional | protect | protectunprotect |
Password password | password | Optional | Not set | Optional. Not security: Excel sheet passwords are removed in seconds Shown when action = protect |
Editable Range editableRange | string | Optional | Not set | Cells still open for typing, such as D2:D500. Without this nothing can be edited Shown when action = protect |
Allow Sorting allowSorting | boolean | Optional | false | Shown when action = protect |
Allow Filtering allowFiltering | boolean | Optional | false | Shown when action = protect |
Allow Formatting allowFormatting | boolean | Optional | false | Shown when action = protect |
Allow Inserting Rows allowInsertingRows | boolean | Optional | false | Shown when action = protect |
Allow Deleting Rows allowDeletingRows | boolean | Optional | false | Shown when action = protect |
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Create New Excel WorkSheet
Add a new blank sheet to the workbook
Delete Excel WorkSheet
Remove a sheet from an Excel workbook
Duplicate Excel WorkSheet
Make a copy of an existing sheet
Freeze Panes
Keep the headings on screen while the rest of the sheet scrolls
Get Used Range
Find where the data on a sheet starts and ends. Worked out from cells that hold something, so a cell that was formatted and then emptied does not count
Hide Rows, Columns or Sheets
Hide working rows, columns or sheets without deleting them, so the formulas that depend on them still work