跳到主要內容

如何在Excel中一次取消保護多個工作表？

如果您有一個工作簿包含多個具有相同密碼的受保護工作表，現在您需要取消保護它們才能修改某些信息。 也許，您可以使用Excel中的“取消保護工作表”來逐一取消保護工作表，但是當需要取消保護多個工作表時，這將浪費大量時間。 在這裡，我將向您介紹一些取消保護多個受保護工作表的快速方法。

使用VBA代碼一次取消保護多張紙

使用Kutools for Excel一次取消保護多個工作表

箭頭藍色右氣泡 使用VBA代碼一次取消保護多張紙

如果您擅長VBA代碼，則以下代碼可以幫助您快速取消一次保護多張紙的工作。

1。 按住 ALT + F11 鍵，然後打開 Microsoft Visual Basic for Applications 窗口。

2。 點擊 插入 > 模塊，然後將以下代碼粘貼到“模塊窗口”中。

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。 然後按 F5 鍵運行代碼，然後輸入您為受保護工作表申請的密碼。 （受保護的工作表必須具有相同的密碼）請參見屏幕截圖：

4。 點擊 OK，並且受保護的工作表已被立即取消保護。

箭頭藍色右氣泡 使用Kutools for Excel一次取消保護多個工作表

Excel的Kutools“ 取消保護工作表 是一種方便的工具，可以幫助您快速取消一次使用同一密碼保護多張紙的保護。

Excel的Kutools : 帶有300多個便捷的Excel加載項，可以在30天內免費試用. 
前往下載
30天免費試用購買
貝寶/ MyCommerce

安裝後 Excel的Kutools，請執行以下操作：

1。 點擊 Kutools 加 > 取消保護工作表，請參見屏幕截圖：

2。 在 取消保護工作表 對話框中，受保護的工作表將列在 下載學習單 列錶框，然後選中要取消保護的工作表名稱，然後單擊 OK，然後在彈出的對話框中輸入您為受保護工作表申請的密碼（受保護工作表必須具有相同的密碼），請參見屏幕截圖：

3。 然後點擊 OK時，會出現一個提示框，提醒您有多少張紙沒有被保護。 然後點擊 OK，所有選定的工作表已在您的工作簿中不受保護。 看截圖：

提示： 要一次保護工作簿中的所有工作表，只需申請 保護工作表 of Excel的Kutools 如下圖所示：

立即下載並免費試用Excel的Kutools！

箭頭藍色右氣泡 演示：使用Kutools for Excel一次保護和取消保護多個工作表

Excel的Kutools：具有300多個方便的Excel加載項，可以在30天內免費試用，沒有任何限制。 立即下載並免費試用！

相關文章：

如何在Excel中一次保護多個工作表？

最佳辦公生產力工具

🤖 Kutools 人工智慧助手：基於以下內容徹底改變數據分析： 智慧執行   |  生成代碼  |  建立自訂公式  |  分析數據並產生圖表  |  呼叫 Kutools 函數...
熱門特色: 尋找、突出顯示或識別重複項   |  刪除空白行   |  合併列或儲存格而不遺失數據   |   沒有公式的回合 ...
超級查詢: 多條件VLookup  |   多值VLookup  |   跨多個工作表的 VLookup   |   模糊查詢 ....
高級下拉列表: 快速建立下拉列表   |  依賴下拉列表   |  多選下拉列表 ....
欄目經理: 新增特定數量的列  |  移動列  |  切換隱藏列的可見性狀態  |  比較範圍和列 ...
特色功能: 網格焦點   |  設計圖   |   大方程式酒吧   |  工作簿和工作表管理器   |  資源庫 （自動文字）   |  日期選擇器   |  合併工作表   |  加密/解密單元格   |  按清單發送電子郵件   |  超級濾鏡   |   特殊過濾器 （過濾粗體/斜體/刪除線...）...
前 15 個工具集:  12 文本 工具 (添加文本, 刪除字符，...）   |   50+ 圖表 類型 (甘特圖，...）   |   40+ 實用 公式 (根據生日計算年齡，...）   |   19 插入 工具 (插入二維碼, 從路徑插入圖片，...）   |   12 轉化 工具 (數字到單詞, 貨幣兌換，...）   |   7 合併與拆分 工具 (高級合併行, 分裂細胞，...）   |   ... 和更多

使用 Kutools for Excel 增強您的 Excel 技能，體驗前所未有的效率。 Kutools for Excel 提供了 300 多種進階功能來提高生產力並節省時間。  點擊此處獲取您最需要的功能...

產品描述

Office選項卡為Office帶來了選項卡式界面，使您的工作更加輕鬆

  • 在Word，Excel，PowerPoint中啟用選項卡式編輯和閱讀，發布者，Access，Visio和Project。
  • 在同一窗口的新選項卡中而不是在新窗口中打開並創建多個文檔。
  • 將您的工作效率提高 50%，每天為您減少數百次鼠標點擊！
Comments (12)
No ratings yet. Be the first to rate!
Rob
Rob
This comment was minimized by the moderator on the site
Nice - thank you so much! Worked like as charm.

I assume there is also a "Lock Everything back Up" Option??
Reply
0
0
LL
LL
This comment was minimized by the moderator on the site
This code worked for years, but now it doesn't :( It always says password error, but if I individually unlock each tab it is fine. Did something change with excel to wreck the code?
Reply
0
0
skyyang
skyyang     LL
This comment was minimized by the moderator on the site
Hello, LL,
I have tested the code, it works well in my workbook, could you upload your file here if you don't mind? we can help to check the problem.
Or you can try our KTE feature this article introduces, it supports a 30-day free trial with full features, you can download it here: https://www.extendoffice.com/download/kutools-for-excel.html.

Thank you!
Reply
Report
0
0
Ali
Ali
This comment was minimized by the moderator on the site
Hi,

in my work i have to deal every day with multiple excel files , and inside each one protect sheets, all has same password , 7b7b3b1b5b5b5 is there any way to unprotect all the sheets inside for example ( 100 excel files and more ).

best regards,
Reply
0
0
MandyZhou
MandyZhou     Ali
This comment was minimized by the moderator on the site
Hello Ali,

Glad to help. You can use our Decrypt workbooks feature of Kutools Plus of Kutools for Excel. You can choose no matter how many files, then input the passward. Just a few clicks and all is done. Please see the screenshots.

Our Kutools for Excel supports a 30-day free trial with full features. Here is the download link: https://www.extendoffice.com/download/kutools-for-excel.html. Plesae have a try.

Sincerely,
Mandy
View Attachments (2 / 5)
Reply
Report
0
0
Paulo
Paulo
This comment was minimized by the moderator on the site
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?
Reply
0
0
skyyang
skyyang     Paulo
This comment was minimized by the moderator on the site
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:
View Attachments (1 / 5)
Reply
Report
0
0
abvgdh
abvgdh
This comment was minimized by the moderator on the site
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
Reply
0
0
Frank
Frank
This comment was minimized by the moderator on the site
Is it possible to lock sheets, but retain the ability to add rows and use filters.
Reply
0
0
Gurmeet
Gurmeet
This comment was minimized by the moderator on the site
worked !! thanks handy command
Reply
0
0
sachin v rodi
sachin v rodi
This comment was minimized by the moderator on the site
Hello Sir, unprotect multiple sheets at once is very useful for me. thanks!
Reply
0
0
SWHM Tech
SWHM Tech
This comment was minimized by the moderator on the site
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.
Reply
0
0
There are no comments posted here yet
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations