How to Unprotect in Excel

Get FREE Advanced Excel Exercises with Solutions!

In this Excel tutorial, we will learn how to unprotect a sheet or workbook in Excel.

Microsoft Excel is a powerful tool for data management and analysis, and it offers various features to safeguard your sensitive information. One such feature is the ability to protect worksheets and workbooks with passwords, ensuring that only authorized users can make changes. However, there may come a time when you need to unprotect an Excel sheet or workbook for legitimate reasons. In this article, we’ll explore different methods on how to unprotect in Excel, providing you with the knowledge to unlock your files and regain access.

Table of Contents Expand

How to Use Unprotect Sheet or Unprotect Workbook Option to Unprotect in Excel

Step 1: Open the Protected Excel File

Start by opening the Excel file that you want to unprotect. If the file has a password, you will need to enter it to access the contents.

Step 2: Navigate to the Review Tab

Once the file is open, go to the “Review” tab on the Excel ribbon.

Step 3: Locate the Unprotect Sheet or Unprotect Workbook Option

Look for the “Unprotect Sheet” or “Unprotect Workbook” option within the “Changes” group. Click on the option that corresponds to your needs.

Step 4: Enter the Password

If the sheet or workbook is password-protected, you will be prompted to enter the password. Provide the correct password and click “OK” to remove the protection.

How to Unprotect Workbook or Worksheet Using VBA in Excel

Step 1: Open the VBA Editor

From the workbook you want to unprotect, press Alt + F11 to open the VBA editor.

Step 2: Locate the Project Explorer

In the VBA editor, locate the Project Explorer window. Find and select the workbook you want to unprotect.

Step 3: Insert a New Module

Right-click on the selected workbook, choose “Insert,” and then click on “Module” to insert a new module.

Step 4: Insert and Run the Code

Copy and paste the following VBA code into the module:

Sub UnprotectWorkbook()
On Error Resume Next
ActiveWorkbook.Unprotect Password:="YourPassword"
End Sub

Replace “YourPassword” with the actual password. Run the code by clicking the Run button (a green triangle) or pressing the F5 key. This will unprotect your workbook. Similarly, you can unprotect the active worksheet as well. Here is the VBA code for unprotecting only the active sheet of your active workbook.

Sub UnprotectActiveSheetInActiveWorkbook()
    On Error Resume Next
    ActiveWorkbook.ActiveSheet.Unprotect Password:="YourPassword"
End Sub

Knowing how to unprotect in Excel is valuable for users who need to regain access to their files. Whether you choose the built-in options within Excel, utilize VBA, or explore online tools, always exercise caution and prioritize the security of your data. Regularly review and update your password practices to balance accessibility and protection in your Excel workbooks.