Yuav Paub
- Unprotect as owner: Qhib daim ntawv nthuav qhia. Xaiv Review > Unprotect Sheet. Sau tus password siv los tiv thaiv cov ntaub ntawv. Xaiv OK.
- Unprotect yam tsis muaj lo lus zais: Qhib daim ntawv nthuav qhia. Qhib Visual Basic code editor los ntawm xaiv Developer > View code.
- Tom qab ntawd, nkag mus rau tus lej muab hauv kab lus no thiab xaiv Run. Hauv ob peb feeb, tus password yuav tshwm sim. Xaiv OK.
Kab lus no piav qhia yuav ua li cas tiv thaiv Excel phau ntawv ua haujlwm xws li tus tswv ntawm phau ntawv ua haujlwm nrog tus password lossis tus neeg tsis muaj tus password. Cov ntaub ntawv no siv tau rau Excel phau ntawv ua haujlwm hauv Microsoft Excel 365, Microsoft Excel 2019, 2016, thiab 2013.
Yuav ua li cas thiaj qhib phau ntawv Excel ua tus tswv
Microsoft Excel tau ntim nrog cov yam ntxwv. Ib qho zoo li no yog lub peev xwm los tiv thaiv koj cov ntaub ntawv Excel ntawm lub xov tooj ntawm tes, daim ntawv nthuav qhia, lossis qib ntawv ua haujlwm. Qee lub sij hawm nws yuav tsum tsis txhob tiv thaiv Excel phau ntawv ua haujlwm kom ntseeg tau tias cov ntaub ntawv hloov pauv siv tau raug.
Txoj kev no xav tias yog tus tswv ntawm cov ntaub ntawv, koj nco ntsoov tus password siv los tiv thaiv daim ntawv nthuav dav.
-
Qhib daim ntawv tiv thaiv, thiab xaiv Review > Unprotect Sheet. Koj tseem tuaj yeem nyem nyem rau ntawm daim ntawv tiv thaiv, tom qab ntawd xaiv Unprotect Sheet.
Koj tuaj yeem txheeb xyuas daim ntawv tshaj tawm tiv thaiv nyob rau hauv ntu Hloov pauv ntawm Kev Tshawb Xyuas tab ntawm kab. Yog tias daim ntawv nthuav qhia raug tiv thaiv, koj pom qhov kev xaiv Unprotect Sheet.
Image -
Tau tus password siv los tiv thaiv daim ntawv nthuav dav, tom qab ntawd xaiv OK.
Image -
Koj daim ntawv tshaj tawm tam sim no yuav tsis muaj kev tiv thaiv thiab nws tuaj yeem hloov kho.
Image
Yuav ua li cas tiv thaiv phau ntawv Excel tsis paub tus password
Koj tuaj yeem tiv thaiv koj phau ntawv ua haujlwm Excel lossis daim ntawv nthuav qhia thiab tsis tas yuav hloov kho nws hauv qee lub sijhawm, txawm tias xyoo. Tam sim no koj yuav tsum hloov pauv, koj tsis nco qab tus password uas koj tau siv los tiv thaiv daim ntawv no lawm.
Zoo zoo, cov kauj ruam no yuav tso cai rau koj los tiv thaiv koj phau ntawv ua haujlwm siv Virtual Basic tsab ntawv ua tus macro txhawm rau txheeb xyuas tus password.
- Qhib daim ntawv tiv thaiv.
-
Nkag mus rau Visual Basic code editor los ntawm nias ALT+F11 lossis xaiv Developer > Saib Code.
Image -
Nyob rau hauv lub qhov rais Code ntawm daim ntawv tiv thaiv, sau cov cai hauv qab no:
Sub PasswordBreaker()
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On yuam kev Resume Next
For i=65 To 66: Rau j=65 To 66: Rau k=65 To 66
For l=65 To 66: For m=65 To 66: For i1=65 To 66
For i2=65 To 66: Rau i3=65 txog 66: Rau i4=65 rau 66
For i5=65 rau 66: Rau i6=65 rau 66: Rau n=32 txog 126
ActiveSheet. 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 ActiveSheet. ProtectContents=False Then
MsgBox "Ib tug usable password is" & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next
Next: Next: Tom ntej: Next: Next
End Sub
Image -
Select Run los yog nias F5 txhawm rau ua tiav cov cai.
Image -
Tus lej yuav siv sijhawm ob peb feeb los khiav. Thaum ua tiav, koj yuav tau txais ib qho pop-up nrog tus password. Xaiv OK thiab koj daim ntawv tshaj tawm yuav tsis muaj kev tiv thaiv.
No tsis yog tus password qub thiab koj tsis tas yuav nco nws.
