3 ways to unlock a sheet in Excel

You may give a password to protect the worksheet in excel to prevent other users from accidentally or deliberately changing the data in your worksheet. Or, you may want to prevent users from viewing sensitive data in your worksheet.

If you have ever tried to edit a sheet in Excel only to find that all the cells are locked, you know how frustrating it can be. Fortunately, it is easy to unlock a sheet in Excel so that you can make the changes you need. Here is a quick guide on how to do it.

Use the Unprotect Sheet command to unprotect the sheet.

Please follow the below steps to unprotect sheet

1. Click the Review tab
2. Click Unprotect Sheet – to open Unprotect Sheet dialog box
3. In the Unprotect Sheet dialog box, type the password, and then click OK.
4. Save the workbook

Use the Unprotect Workbook command to remove password protection

Workbook protection is a security feature in Microsoft Excel that allows users to protect their workbooks from unauthorized access. Workbook protection is a layer of security that can be applied to an entire workbook. When a workbook is protected, users can still view and edit data, but they cannot make any changes to the structure of the workbook, such as adding or deleting worksheets.

If you have a password protected, you can remove the password protection by using the Unprotect Workbook command.

1. Go to the Review tab
2. Click the Protect Workbook command
3. Enter the password for the workbook
4. Click OK
5. Save the workbook.

Use a macro to unprotect the sheet

Sub UnprotectSheet() 
 'Macro to UnprotectSheet  
      ActiveSheet.Unprotect Password: = "your password" 
End Sub

1. Press Alt+F11 to open VBE
2. Go to Insert
3. Select Module
4. Copy and paste the above code into your module pane
5. Press Save and Close VBE
6. Press Alt + F8
7. Select UnprotectSheet
8. Press Run

Conclusions.

You learned three different ways how to unlock worksheets in excel. VBA Script will help you to unprotect sheets for your automation projects. Another option is to use a third-party add-in.