Unlock both sheets locked for editing and entire Excel workbooks locked for reading. Unlock ALL your Excel files — the program is yours to keep forever! Your Excel stay on your computer, secure from hackers and online predators. You’ll receive a single application that works with Excel, Word and Access files! Excel Macro to UnProtect your Protected Sheet. To Unprotect your already protected sheet, you need to use WorkSheet.unprotect method. To Unprotect a Sheet all you need to pass is the password. No other parameter required to unprotect a sheet. Password is NOT required in all case.
Are you unable to modify cells because they are locked? Here’s how to lock or unlock cells in Microsoft Excel 2016 and 2013.
- Select the cells you wish to modify.
- Choose the “Home” tab.
- In the “Cells” area, select “Format” > “Format Cells“.
- Select the “Protection” tab.
- Uncheck the box for “Locked” to unlock the cells. Check the box to lock them. Select “OK“. As the dialog box says, locking cells or hiding formulas has no effect until you protect the worksheet. You can do so under the “Review” tab by selecting “Protect Sheet“.
FAQ
But, why is “Protect Sheet” is grayed out?
If it’s a shared workbook, “Protect Sheet” may be grayed out. Unshare it by selecting “Review” > “Share Workbook“, then deselect “Allow changes by more than one user…“.
Otherwise, multiple worksheets are selected. Right-click any tab, then select “Ungroup Sheets“.