How to unprotect multiple worksheets at once in Excel?

If you have a workbook contains multiple protected worksheets with the same password, and now you need to unprotect them for modifying some information. Maybe, you can unprotect the sheets one by one with Unprotect Sheet in Excel, but this will waste a lot of time when there are multiple sheets need to be unprotected. Here, I will introduce you some quick ways to unprotect multiple protected sheets.

Unprotect multiple sheets at once with VBA code

Unprotect multiple sheets at once with Kutools for Excel


arrow blue right bubble Unprotect multiple sheets at once with VBA code

If you are good at VBA code, the following code may be help you quickly to unprotect multiple sheets at once.

1. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and paste the following code in the Module Window.

Sub unprotect_all_sheets() 
On Error Goto booboo 
unpass = InputBox("Please enter the password:") 
For Each Worksheet In ActiveWorkbook.Worksheets 
Worksheet.Unprotect Password:=unpass
Next
Exit Sub 
booboo: MsgBox "There is s problem - check your password, capslock, etc." 
End Sub 

3. Then press F5 key to run the code, and enter the password that you have applied for the protected sheets. (the protected sheets must have the same password)See screenshot:

4. Click OK, and the protected sheets have been unprotected at once.


arrow blue right bubble Unprotect multiple sheets at once with Kutools for Excel

Kutools for Excel’s Unprotect Worksheet is a handy tool which can help you quickly to unprotect multiple sheets with the same password at once.

Kutools for Excel : with more than 300 handy Excel add-ins, free to try with no limitation in 30 days

After installing Kutools for Excel, please do as follows:

1. Click Kutools Plus > Unprotect Worksheet, see screenshot:

2. In the Unprotect Worksheet dialog box, the protected sheets will be listed in the Worksheet list box, then check the sheet names that you want to unprotect, and click OK, then input the password that you have applied for the protected sheets (the protected sheets must have the same password) in the popped out dialog box, see screenshot:

3. And then click OK, a prompt box will remind you how many sheets have been unprotected. Then click OK, all the selected sheets have been unprotected in your workbook. See screenshot:

Tips: To protect all of the worksheets within your workbook at once, you just need to apply Protect Worksheet of Kutools for Excel as following screenshot shown:

Download and free trial Kutools for Excel Now!


arrow blue right bubble Demo: Protect and Unprotect multiple sheets at once with Kutools for Excel

Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. Download and free trial Now!

Related article:

How to protect multiple worksheets at once in Excel?


The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Paulo · 10 months ago
    I just installed it, but I don't see the "Enterprise" tab on the menu. I wanted to test the feature to unprotect multiple sheets at once, but can't find that feature anywhere. The options I have on my menu are Kutools and Kutools Plus, but not Enterprise. What am I missing?
    • To post as a guest, your comment is unpublished.
      skyyang · 10 months ago
      Hello, Paulo,
      Sorry for this, the Enterprise tab has been renamed as Kutools Plus, you can find the Unprotect Worksheet from the Kutools Plus tab, please check the below screenshot:
  • To post as a guest, your comment is unpublished.
    abvgdh · 1 years ago
    When you say "Unprotect multiple sheets at once with Kutools", does it actually do it at once, in parallel, or does it still do it sequentially? (Does this provide a speed improvement over doing it sequentially?) thank you
  • To post as a guest, your comment is unpublished.
    Frank · 4 years ago
    Is it possible to lock sheets, but retain the ability to add rows and use filters.
  • To post as a guest, your comment is unpublished.
    Gurmeet · 4 years ago
    worked !!
    thanks
    handy command
  • To post as a guest, your comment is unpublished.
    sachin v rodi · 5 years ago
    Hello Sir,
    unprotect multiple sheets at once is very useful for me. thanks!
  • To post as a guest, your comment is unpublished.
    SWHM Tech · 6 years ago
    I downloaded the kutools (trial version) and installed it as an administrator. I opened a workbook that had 12 worksheets that were protected with same password. Ran the unprotect utility and followed instructions. it said that all Sucessfully unprotected 12 sheets. when I tried to edit them it said the worksheet is password proctected. It did not work. I am not doing something correctly.