Quick Protect
Quick Protect allows you to protect all the worksheets in a workbook in a single pass.
Form Fields
- Password: Optional password to secure the sheet protection. (Note: Spreadspeed does not save the password. It uses the built-in password protection mechanism provided by Excel.)
- Hide password characters: Determines whether the password characters are displayed as you type them.
- Apply to: All worksheets plus workbook structure [1] or just the active worksheet.
- Unlock cells with these styles: After protection, check cell types can be edited, and all other cells are locked. These feature leverages built-in and custom styles to determine whether cells are unlocked.
[1] Workbook structure affects the order of the sheet tabs, sheet names, and whether sheets can be added, deleted, or hidden and unhidden.