Sep 3, 2022 12:00 AM

Why Cant You UnProtect All Excel Sheets In Group Mode - 2506

External YouTube Channel

Danny from Stuart Florida noticed that when you group all worksheets in an Excel workbook, you can not protect or unprotect the worksheets. This episode offers two very short VBA macros that you can use to unprotect all sheets and then re-protect them with a password.

Lock or unlock specific areas of a protected worksheet

By default, protecting a worksheet locks all cells so none of them are editable. To enable some cell editing, while leaving other cells locked, it's possible to unlock all the cells.

https://support.microsoft.com/en-us/office/lock-or-unlock-specific-areas-of-a-protected-worksheet-75481b72-db8a-4267-8c43-042a5f2cd93a

Protect a worksheet

To prevent other users from accidentally or deliberately changing, moving, or deleting data in a worksheet, you can lock the cells on your Excel worksheet and then protect the sheet with a password. Say you own the team status report worksheet, where you want team members to add data in specific cells only and not be able to modify anything else.

https://support.microsoft.com/en-us/office/protect-a-worksheet-3179efdb-1285-4d49-a9c3-f4ca36276de6

How to protect and unprotect Excel sheet with or without passwort

When sharing your worksheets with other people or sending your Excel files outside of your organization, you may want to prevent other users from changing cells that shouldn't be changed, and also from moving or deleting important data in your worksheet or workbook.

https://www.ablebits.com/office-addins-blog/protect-unprotect-excel-sheet-password/