How to Protect Workbook in WPS on macOS

Use Protect Workbook in 2 how-to topics on macOS, including turning protection on and removing it; 2 items are available without membership and 0 items are membership-related.

How-to Index

How-to Guide

1. Turn On Workbook Protection

Entry: Review tab → Protect Workbook

1. Open the workbook that you want to protect.
2. Click Protect Workbook on the Review tab.
3. In the dialog box, select Structure to lock actions such as adding, deleting, moving, renaming, hiding, or unhiding sheets.
4. If needed, select Windows to also lock window size and position.
5. Enter a password and confirm it.
6. Click OK, then save the file so the protection setting takes effect.

Success Criteria

• Interface result: The workbook is now in a protected state.
• What you can do next: You can continue editing cell content and save the file.
• No unwanted effect: Sheet-structure actions remain restricted until protection is removed.

Tips While Using

• Common mistake: If you do not save the file after setting protection, the change may not be written to the workbook.
• Environment note: If a password is set, the same password is required later to remove protection.

2. Remove Workbook Protection

Entry: Review tab → Unprotect Workbook

1. Open the workbook that already has workbook protection turned on.
2. Click Unprotect Workbook on the Review tab.
3. Enter the password that was set earlier.
4. Click OK to remove workbook structure protection.

Success Criteria

• Interface result: Workbook protection is removed.
• What you can do next: You can add, delete, move, rename, hide, or unhide sheets again.
• No unwanted effect: Removing workbook protection does not automatically change cell content.

Tips While Using

• Common mistake: Entering the wrong password prevents the workbook from being unprotected.
• Environment note: If the password is forgotten, confirm the original password before continuing.