Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

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


Uprotect multiple worksheets with same password at once:

Kutools for Excel's Unprotect Worksheet utility can help you to unprotect multiple worksheets in a workbook quickly with one click.

doc-unprotect-sheets1

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


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("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:

doc-unprotect-sheets1

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 60 days

After installing Kutools for Excel, please do as follows:

1. Click Enterprise > Unprotect Worksheet, see screenshot:

doc-unprotect-sheets2

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:

doc-unprotect-sheets2

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:

doc-unprotect-sheets5

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:

doc-unprotect-sheets5

 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 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!


Related article:

How to protect multiple worksheets at once in Excel?


Recommended Productivity Tools

Ribbon of Excel (with Kutools for Excel installed)

300+ Advanced Features Increase Your Productivity by 71%, and Help You To Stand Out From Crowd!

Would you like to complete your daily work quickly and perfectly? Kutools For Excel brings 300+ cool and powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) for 1500+ work scenarios, helps you solve 82% Excel problems.

  •  Deal with all complicated tasks in seconds, help to enhance your work ability, get success from the fierce competition, and never worry about being fired.
  •  Save a lot of work time, leave much time for you to love and care the family and enjoy a comfortable life now.
  •  Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands, and give you a healthy body.
  •  Become an Excel expert in 3 minutes, and get admiring glance from your colleagues or friends.
  •  No longer need to remember any painful formulas and VBA codes, have a relaxing and pleasant mind, give you a thrill you've never had before.
  •  Spend only $39, but worth than $4000 training of others. Being used by 110,000 elites and 300+ well-known companies.
  •  60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years. Buy once, use forever.
  •  Change the way you work now, and give you a better life immediately!

Office Tab Brings Efficient And Handy Tabs to Office (include Excel), Just Like Chrome, Firefox, And New IE

  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Open and create documents in new tabs of same window, rather than in new windows.
  • Help you work faster and easily stand out from the crowd! One second to switch between dozens of open documents!
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.
    abvgdh · 5 months 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 · 2 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 · 3 years ago
    worked !!
    thanks
    handy command
  • To post as a guest, your comment is unpublished.
    sachin v rodi · 3 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 · 5 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.