『壹』 excel表怎麼取消密碼保護
他這個表格的話，原本其實是沒有密碼保護，那如果你弄的話，那你只要從設置那裡面可就可以取消密碼保護
『貳』 在Excel中怎麼將密碼保護取消
不同的版本取消的方法略有不同，excel2007的文檔加密：
1.
打開需要加密的excel2007文檔，點擊左上角的office標識，在彈出的對話框中選擇「另存為」，或者直接使用快捷鍵「f12」調出對應窗口；
2.
在彈出的另存為窗口左下角，找到「工具」選項。注意這里是關鍵，點擊它，在彈出的窗口中，選擇「常規選項」，在彈出的對話窗口中，就可以對該excel文檔進行密碼設置；
3.
密碼設置分為「打開許可權密碼」、「修改許可權密碼」以及「建議只讀」
。
excel2003的文檔加密：
工具--選項--安全性--此工作簿的文件共享設置里修改許可權密碼處輸入你設置的密碼，確定，重復輸入即可。
取消密碼的方法就是，按照上面的操作步驟打開需要設置密碼的地方，把密碼（顯示星號）刪除掉，再保存就可以了。
『叄』 EXCEL怎麼撤消保護沒有密碼
首先我們先在電腦桌面上找到我們要使用的軟體Excel2016並打開，接著找到其中一個已近加密過的文檔。
找到之後，輸入密碼進入該文檔。接著找到位於上方菜單欄中的「文件」選項並點擊，然後進行下一步操作。
在接下來的頁面，選擇「信息」，在信息一欄中，選擇第一項「保護工作簿」。並在該選項中找到「用密碼進行加密」。
最後我們點擊「用密碼進行加密」，彈出一個輸入密碼的窗口，只需將輸入欄清空，點擊「確定」，這樣我們就撤銷的Excel的密碼保護。
『肆』 EXCEL工作表保護密碼忘記了，如何撤消工作表保護
撤銷是不能撤銷的，只能通過破解密碼來實現，可以用修改後綴名稱的方法。
工具：華碩電腦
1、首先找到Excel表格，修改後綴名稱xlsx改為演示操作表格rar，如下圖所示
『伍』 Excel 表格怎麼去掉保護密碼
Excel工作表保護密碼破解方法
一個excel文檔要修改其中的內容，可是被保護了，找了一堆破解軟體，要麼需要購買，要麼是破解打開密碼的，非保護密碼。好不容易找到解決方案！
excel保護密碼破解(絕對經典) 如果你的Excel文件設置了保護密碼而遺忘了,那麼請依照下面的步驟來操作,也許會有奇跡出現.不需要多麼高難度的操作和專業的軟體支持.簡單.方便.費時一般最多兩分鍾. (建議:操作前把原文件COPY一份) 方法:
1打開文件
2工具---宏----錄制新宏---輸入名字如:aa
3停止錄制(這樣得到一個空宏)
4工具---宏----宏,選aa,點編輯按鈕
5刪除窗口中的所有字元(只有幾個),替換為下面的內容：
Public Sub AllInternalPasswords()
' Breaks worksheet and workbook structure passwords. Bob McCormick
' probably originator of base code algorithm modified for coverage
' of workbook structure / windows passwords and for multiple passwords
'
' Norman Harker and JE McGimpsey 27-Dec-2002 (Version 1.1)
' Modified 2003-Apr-04 by JEM: All msgs to constants, and
' eliminate one Exit Sub (Version 1.1.1)
' Reveals hashed passwords NOT original passwords
Const DBLSPACE As String = vbNewLine & vbNewLine
Const AUTHORS As String = DBLSPACE & vbNewLine & _
"Adapted from Bob McCormick base code by" & _
"Norman Harker and JE McGimpsey"
Const HEADER As String = "AllInternalPasswords User Message"
Const VERSION As String = DBLSPACE & "Version 1.1.1 2003-Apr-04"
Const REPBACK As String = DBLSPACE & "Please report failure " & _
"to the microsoft.public.excel.programming newsgroup."
Const ALLCLEAR As String = DBLSPACE & "The workbook should " & _
"now be free of all password protection, so make sure you:" & _
DBLSPACE & "SAVE IT NOW!" & DBLSPACE & "and also" & _
DBLSPACE & "BACKUP!, BACKUP!!, BACKUP!!!" & _
DBLSPACE & "Also, remember that the password was " & _
"put there for a reason. Don't stuff up crucial formulas " & _
"or data." & DBLSPACE & "Access and use of some data " & _
"may be an offense. If in doubt, don't."
Const MSGNOPWORDS1 As String = "There were no passwords on " & _
"sheets, or workbook structure or windows." & AUTHORS & VERSION
Const MSGNOPWORDS2 As String = "There was no protection to " & _
"workbook structure or windows." & DBLSPACE & _
"Proceeding to unprotect sheets." & AUTHORS & VERSION
Const MSGTAKETIME As String = "After pressing OK button this " & _
"will take some time." & DBLSPACE & "Amount of time " & _
"depends on how many different passwords, the " & _
"passwords, and your computer's specification." & DBLSPACE & _
"Just be patient! Make me a coffee!" & AUTHORS & VERSION
Const MSGPWORDFOUND1 As String = "You had a Worksheet " & _
"Structure or Windows Password set." & DBLSPACE & _
"The password found was: " & DBLSPACE & "$$" & DBLSPACE & _
"Note it down for potential future use in other workbooks by " & _
"the same person who set this password." & DBLSPACE & _
"Now to check and clear other passwords." & AUTHORS & VERSION
Const MSGPWORDFOUND2 As String = "You had a Worksheet " & _
"password set." & DBLSPACE & "The password found was: " & _
DBLSPACE & "$$" & DBLSPACE & "Note it down for potential " & _
"future use in other workbooks by same person who " & _
"set this password." & DBLSPACE & "Now to check and clear " & _
"other passwords." & AUTHORS & VERSION
Const MSGONLYONE As String = "Only structure / windows " & _
"protected with the password that was just found." & _
ALLCLEAR & AUTHORS & VERSION & REPBACK
Dim w1 As Worksheet, w2 As Worksheet
Dim i As Integer, j As Integer, k As Integer, l As Integer
Dim m As Integer, n As Integer, i1 As Integer, i2 As Integer
Dim i3 As Integer, i4 As Integer, i5 As Integer, i6 As Integer
Dim PWord1 As String
Dim ShTag As Boolean, WinTag As Boolean
Application.ScreenUpdating = False
With ActiveWorkbook
WinTag = .ProtectStructure Or .ProtectWindows
End With
ShTag = False
For Each w1 In Worksheets
ShTag = ShTag Or w1.ProtectContents
Next w1
If Not ShTag And Not WinTag Then
MsgBox MSGNOPWORDS1, vbInformation, HEADER
Exit Sub
End If
MsgBox MSGTAKETIME, vbInformation, HEADER
If Not WinTag Then
MsgBox MSGNOPWORDS2, vbInformation, HEADER
Else
On Error Resume Next
Do 'mmy do loop
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
With ActiveWorkbook
.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If .ProtectStructure = False And _
.ProtectWindows = False Then
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
MsgBox Application.Substitute(MSGPWORDFOUND1, _
"$$", PWord1), vbInformation, HEADER
Exit Do 'Bypass all for...nexts
End If
End With
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Loop Until True
On Error GoTo 0
End If
If WinTag And Not ShTag Then
MsgBox MSGONLYONE, vbInformation, HEADER
Exit Sub
End If
On Error Resume Next
For Each w1 In Worksheets
'Attempt clearance with PWord1
w1.Unprotect PWord1
Next w1
On Error GoTo 0
ShTag = False
For Each w1 In Worksheets
'Checks for all clear ShTag triggered to 1 if not.
ShTag = ShTag Or w1.ProtectContents
Next w1
If ShTag Then
For Each w1 In Worksheets
With w1
If .ProtectContents Then
On Error Resume Next
Do 'Dummy do loop
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If Not .ProtectContents Then
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
MsgBox Application.Substitute(MSGPWORDFOUND2, _
"$$", PWord1), vbInformation, HEADER
'leverage finding Pword by trying on other sheets
For Each w2 In Worksheets
w2.Unprotect PWord1
Next w2
Exit Do 'Bypass all for...nexts
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Loop Until True
On Error GoTo 0
End If
End With
Next w1
End If
MsgBox ALLCLEAR & AUTHORS & VERSION & REPBACK, vbInformation, HEADER
End Sub
6關閉編輯窗口
7工具---宏-----宏,選AllInternalPasswords,運行,確定兩次,等2分鍾,再確定.OK,沒有密碼了!!
『陸』 如何取消excel密碼
具體操作步驟如下：
一、打開excel，先錄入密碼，確定打開要取消密碼的excel文件。
『柒』 EXCEL 怎麼取消密碼保護
1、雙擊打開一個設置了讀、防寫，工作表保護，工作薄保護的excel文件，這時會要求輸入密碼，我們依次輸入「讀許可權」密碼和「寫許可權」密碼後，打開文件。
『捌』 怎麼解除excel密碼保護
打開文檔後，通過文件菜單中「另存為」，將文檔存為rtf格式。保存好文件後，先關掉文檔再打開另存的文件，選擇工具欄中的「解除文檔保護」命令，不用填寫密碼就可以解除此文件的「文檔保護功能」，而且任何信息都不會丟失。用Office Password Remover這個軟體可以打開。
使用方法：
首先運行解壓好的OPRemove.exe 這個程式，打開程式後能看到中間文本框後面有個類似目錄的按鈕。
選擇後出現下圖的畫面，點擊移除密碼。
呆幾秒鍾後便出現「該文件已被成功破解」，點確定即可，這時候就大功告成了。 在這里要注意的是，破解後的文章名字會有點變化，加了「DEMO」這四個字母，翻譯過來就是示範的意思，不必在意，重命名去掉就能了。
『玖』 怎樣取消EXCEL表格的密碼保護
如果可以用只讀方式打開這個文件，那麼只要打開後「另存為」一個就行了，另存後的文件就沒有密碼了。
『拾』 EXCEL工作表保護密碼不記得了，如何撤消EXCEL工作表保護急急急急啊
在excel中取消工作表的保護命令的方法：
1.打開excel，運行視圖—宏—錄制新宏—輸入宏名如:aa（aa是可隨意輸入）。