Ib qho zoo tshaj plaws ntawm Excel yog lub peev xwm los tiv thaiv koj cov ntaub ntawv ntawm txhua qib. Koj tuaj yeem xaiv los tiv thaiv Phau Ntawv Ua Haujlwm los ntawm cov qauv kev hloov pauv, txhais tau hais tias cov neeg tsis tau tso cai tsis tuaj yeem hloov tus lej lossis xaj ntawm nplooj ntawv hauv phau ntawv ua haujlwm. Koj tseem tuaj yeem tsim tus password los tiv thaiv ib tus neeg los ntawm kev hloov pauv cov ntawv ua haujlwm, uas txhais tau hais tias lawv tsis tuaj yeem luam, kho lossis tshem tawm cov ntsiab lus ntawm cov ntawv ua haujlwm. Thiab koj tuaj yeem teeb tsa tus password qhib uas yuav tiv thaiv ib tus neeg los ntawm kev qhib cov ntaub ntawv tshwj tsis yog lawv muaj tus password.
Thaum cov passwords no tuaj yeem siv tau, lawv tuaj yeem tiv thaiv koj los ntawm kev nkag lossis hloov kho cov ntaub ntawv thaum koj xav tau. Yog tias koj tsis tuaj yeem nkag mus rau Excel cov ntaub ntawv lossis daim ntawv nthuav qhia vim tias koj tsis paub tus password lossis tsis nco qab nws, tsab xov xwm no yuav pab tau zoo. Hauv nws, peb yuav saib qee txoj hauv kev uas koj tuaj yeem tshem tus password los ntawm Excel daim ntawv.
Part 1: Qhov tshwm sim ntawm kev tshem tawm lo lus zais ntawm Excel yog dab tsi
Ua ntej sib tham txog yuav ua li cas koj thiaj li tshem tau lo lus zais los ntawm Excel daim ntawv, peb xav tias peb yuav tsum tau hais txog lub tswv yim dav dav ntawm kev qhib lo lus zais thiab muaj peev xwm qhib Excel lo lus zais.
Kev qhib lo lus zais yog txheej txheem uas siv ntau txoj hauv kev los rov qab los yog tshem tus password ntawm cov ntaub ntawv khaws cia lossis xa mus los ntawm lub khoos phis tawj. Ib txoj hauv kev siv tshaj plaws los tshem tawm tus password yog brute force attack method. Txoj kev no siv txoj kev twv uas pheej twv twv sib txawv passwords kom txog thaum pom tus password kom raug. Yog li dab tsi yog qhov ua tau kom tshem tawm Excel lo lus zais? Qhov tseeb tau hais, tsis muaj qhov kev pab cuam uas tuaj yeem lav 100% kev vam meej hauv kev ua lag luam. Tab sis qhov kev pab cuam zoo heev los tiv thaiv Excel nplooj ntawv tuaj yeem ua rau lub sijhawm luv luv. Yog li ntawd, lub caij nyoog ntawm kev tshem tawm tus yuam sij tuaj yeem nce ntxiv.
Rau cov neeg tsis yog kev siv tshuab, peb xav kom koj sim Excel lo lus zais unlocker los pab koj tshem lo lus zais ntawm Excel cov ntaub ntawv.
Part 2: Yuav ua li cas tshem tus password sai sai
Yog tias koj tsis tuaj yeem qhib Excel daim ntawv tsis muaj tus password, cov hauv qab no yog qee qhov kev xaiv uas koj tuaj yeem sim.
Txoj Kev 1: Tshem Password ntawm Excel Cov Ntaub Ntawv nrog Passper rau Excel
Rau qhov zoo tshaj plaws ntawm txoj kev vam meej, koj yuav xav siv qhov kev pab cuam muaj zog: Passper rau Excel . Qhov no yog ib lo lus zais xauv qhov kev pab cuam uas tuaj yeem pab tau koj hla tus password qhib hauv ib daim ntawv Excel, txawm tias qhov tseeb version. Nws muaj ntau tus nta tsim los ua kom rov qab lo lus zais yooj yim heev. Lawv suav nrog cov hauv qab no:
- Faster password unlock ceev : Nws muaj ib tus password qhib ceev tshaj plaws ntawm kev ua lag luam, muaj peev xwm txheeb xyuas yuav luag 3,000,000 tus password ib ob.
- Qhov ntau tshaj qhov yuav rov qab tau tus password - Muab cov kev xaiv rau koj xaiv los ntawm 4 hom kev tawm tsam thiab phau ntawv txhais lus ntawm ntau lab tus passwords nquag siv, ntxiv qhov ua kom muaj feem ntawm tus password rov qab thiab txo lub sijhawm rov qab.
- Tsis muaj ntaub ntawv poob : Tsis muaj ib qho ntawm cov ntaub ntawv hauv koj daim ntawv Excel yuav raug cuam tshuam los ntawm txoj kev rov qab los.
- Cov ntaub ntawv kev ruaj ntseg : Koj tsis tas yuav upload koj cov ntaub ntawv rau lawv lub server, yog li ntawd, koj cov ntaub ntawv ntiag tug yog 100% tau cog lus tseg.
- Tsis muaj kev txwv : Qhov kev zov me nyuam tau sib xws nrog txhua lub versions ntawm Windows thiab versions ntawm Excel. Tsis tas li ntawd, tsis muaj kev txwv ntawm cov ntaub ntawv loj.
Nov yog qhov koj tuaj yeem siv Passper rau Excel los qhib cov ntaub ntawv Excel tiv thaiv tus password.
Kauj ruam 1 : Nruab Passper rau Excel ntawm koj lub computer thiab tom qab ntawd tso nws. Hauv lub qhov rais loj, nyem "Rov qab Passwords".
Kauj ruam 2 : Nyem "+" khawm xaiv Excel daim ntawv koj xav kom tsis txhob tiv thaiv. Thaum cov ntaub ntawv ntxiv rau qhov kev pab cuam, xaiv hom nres koj xav siv thiab nyem "Rov qab." Hom kev tawm tsam koj xaiv yuav nyob ntawm qhov nyuaj ntawm tus password thiab seb koj puas muaj lub tswv yim dab tsi nws yuav yog.
Kauj ruam 3 : Thaum koj xaiv hom kev tawm tsam, coj mus rhaub rau ntawm "Rov qab" khawm thiab Passper rau Excel yuav pib ua haujlwm tam sim ntawd kom rov qab tau tus password. Tom qab ob peb feeb, cov txheej txheem yuav ua tiav thiab koj yuav tsum pom tus password ntawm qhov screen.
Koj tuaj yeem siv tus password rov qab los qhib cov ntaub ntawv Excel tiv thaiv tam sim no.
Txoj Kev 2: Tshem tawm lo lus zais los ntawm Excel cov ntaub ntawv online
Tsis tas yuav nruab ib qho software hauv koj lub computer los txiav txim siab qhib lo lus zais hauv koj daim ntawv Excel. Koj tuaj yeem siv ib qho ntawm ntau cov cuab yeej online tsim los rau txoj haujlwm ntawd. Kev siv cov cuab yeej online yuav zoo tagnrho rau koj yog tias cov ntaub ntawv tsis muaj cov ntaub ntawv tseem ceeb thiab lo lus zais hauv nqe lus nug tseem tsis muaj zog. Feem ntau cov cuab yeej hauv online siv brute force nres rov qab txoj kev thiab yog li tsuas yog siv tau li 21% ntawm lub sijhawm. Muaj qee cov cuab yeej online uas muaj 61% kev ua tiav, tab sis lawv yog cov cuab yeej hwm, txhais tau tias koj yuav tsum them nyiaj siv lawv.
Tab sis tej zaum qhov tsis zoo tshaj plaws ntawm kev siv cov cuab yeej online yog qhov tseeb tias koj yuav tsum xa cov ntaub ntawv Excel rau hauv online platform. Qhov no ua rau muaj kev phom sij rau cov ntaub ntawv hauv Excel vim tias koj tsis paub tias tus tswv ntawm lub cuab yeej online yuav ua li cas nrog koj cov ntaub ntawv thaum tus password raug tshem tawm.
Cons ntawm txoj kev no:
- Tsawg qhov ua tau zoo : Rov qab tus nqi qis heev, tsawg dua 100% kev ua tiav.
- Cov ntaub ntawv loj txwv : Online Excel password unlockers ib txwm muaj kev txwv ntawm cov ntaub ntawv loj. Rau qee tus password unlockers, cov ntaub ntawv loj tsis tuaj yeem tshaj 10 MB.
- Rov qab qeeb qeeb : Thaum siv Excel lo lus zais qhib online, koj yuav tsum muaj kev sib txuas hauv internet ruaj khov thiab muaj zog. Txwv tsis pub, cov txheej txheem rov qab yuav qeeb tiag tiag lossis txawm daig.
Part 3: Hla Excel lo lus zais los hloov kho
Raws li peb tau hais ua ntej, nws kuj tsis zoo li yuav pom cov ntaub ntawv Excel uas tsis tuaj yeem hloov kho. Tus tswv ntawm cov ntaub ntawv tuaj yeem tsim cov kev txwv uas ua rau nws nyuaj rau cov neeg siv los hloov cov ntaub ntawv cov ntsiab lus. Hauv qhov no, koj tuaj yeem sim ib qho ntawm cov kev daws teeb meem hauv qab no:
Txoj Kev 1: Siv Passper rau Excel (100% Kev Ua Tau Zoo)
Ntxiv rau Excel lo lus zais rov qab, Passper rau Excel Nws kuj yog ib qho cuab yeej zoo rau kev qhib Excel spreadsheets/worksheets/workbooks. Nrog ib tug nias, tag nrho cov kev kho thiab formatting txwv yuav raug tshem tawm nrog ib tug 100% kev vam meej.
Nov yog yuav ua li cas qhib koj daim ntawv Excel / phau ntawv ua haujlwm:
Kauj ruam 1 : Qhib Passper rau Excel ntawm koj lub khoos phis tawj thiab tom qab ntawd nyem "Tshem tawm Cov Kev Txwv."
Kauj ruam 2 : Nyem "Xaiv ib cov ntaub ntawv" import cov ntaub ntawv rau hauv qhov kev pab cuam.
Kauj ruam 3 : Thaum daim ntawv ntxiv, nyem "Delete" thiab qhov kev zov me nyuam yuav tshem tawm cov kev txwv ntawm daim ntawv hauv 2 vib nas this xwb.
Txoj Kev 2: Tshem tawm Excel Passwords los ntawm Hloov Cov Ntaub Ntawv Ntxiv
Yog tias koj siv MS Excel 2010 lossis ntxov dua, koj tuaj yeem qhib cov ntaub ntawv los ntawm kev hloov cov ntaub ntawv txuas ntxiv. Nov yog koj ua li cas.
Kauj ruam 1 : Pib los ntawm kev tsim ib daim ntawv theej ntawm lo lus zais tiv thaiv Excel cov ntaub ntawv, yog li koj muaj ib daim ntawv luam thaum muaj qee yam yuam kev.
Kauj ruam 2 : Txoj cai-nias cov ntaub ntawv thiab xaiv "Rename." Hloov cov ntaub ntawv txuas ntxiv los ntawm ".csv" lossis ".xls" rau ".zip".
Kauj ruam 3 : Unzip cov ntsiab lus ntawm cov ntaub ntawv Zip tsim tshiab thiab tom qab ntawd mus rau "xl\worksheets\". Nrhiav daim ntawv ua haujlwm uas koj xav qhib. Txoj nyem rau ntawm nws thiab xaiv qhov "Kho" xaiv qhib cov ntaub ntawv hauv Notepad.
Kauj ruam 4 : Siv cov haujlwm "Ctrl + F" los qhib cov haujlwm tshawb nrhiav thiab tshawb rau "SheetProtection". Koj tab tom nrhiav rau kab ntawv uas pib nrog; «
Kauj ruam 5 : Tshem tawm tag nrho cov kab ntawv thiab tom qab ntawd txuag cov ntaub ntawv thiab kaw nws. Tam sim no hloov cov ntaub ntawv txuas ntxiv mus rau .csv lossis .xls.
Koj yuav tsis xav tau tus password ntxiv lawm thaum koj xav hloov lossis hloov daim ntawv ua haujlwm.
Cons ntawm txoj kev no:
- Txoj kev no tsuas yog ua haujlwm rau Excel 2010 thiab cov ntawv dhau los.
- Koj tsuas tuaj yeem qhib ib daim ntawv ua haujlwm ntawm ib lub sijhawm. Yog tias koj muaj ntau daim ntawv ua haujlwm tiv thaiv tus password hauv Excel, koj yuav tsum rov ua cov kauj ruam saum toj no rau txhua daim ntawv.
Txoj Kev 3: Tau txais Excel Password los ntawm Google Sheets
Google Drive tau tshaj tawm qhov hloov tshiab tshiab los txhawb cov ntaub ntawv MS Office uas tiv thaiv tus password. Google Drive muab txoj hauv kev yooj yim dua los qhib cov ntaub ntawv Excel thaum koj xav hloov nws. Cov kauj ruam hauv qab no yuav qhia koj yuav ua li cas qhib cov ntaub ntawv Excel tiv thaiv tus password hauv Google Sheets.
Kauj ruam 1 : Mus rau Google Drive hauv ib qho browser ntawm koj lub computer thiab kos npe yog tias koj tsis tau.
Kauj ruam 2 : Nyem qhov "Tshiab" tab thiab xaiv Google Sheets. Yog tias koj twb tso koj cov ntaub ntawv Excel xauv rau hauv koj lub Drive, koj tuaj yeem xaiv "Qhib" qhib cov ntaub ntawv ncaj qha. Txwv tsis pub, koj yuav tsum upload koj cov ntaub ntawv los ntawm txhaj rau "Ntshuam" kev xaiv.
Kauj ruam 3 : Tam sim no qhib cov ntaub ntawv Excel tiv thaiv thiab tom qab ntawd nyem rau ntawm lub ces kaum sab laug kom xaiv tag nrho cov hlwb hauv daim ntawv ntawd.
Kauj ruam 4 : Nyem "Copy" lossis nias Ctrl + C.
Kauj ruam 5 : Tam sim no khiav koj MS Excel program thiab nias Ctrl + V. Tag nrho cov ntaub ntawv nyob rau hauv lo lus zais tiv thaiv Excel spreadsheet yuav raug xa mus rau phau ntawv tshiab no. Tom qab ntawd koj tuaj yeem hloov kho cov ntaub ntawv raws li koj xav tau.
Cons ntawm txoj kev no:
- Txoj kev no siv sijhawm ntau yog tias muaj ntau daim ntawv ua haujlwm kaw hauv koj daim ntawv Excel.
- Google Sheets yuav tsum muaj kev sib txuas hauv Is Taws Nem ruaj khov kom xa cov ntaub ntawv. Yog tias koj qhov kev sib txuas hauv Is Taws Nem tsis muaj zog lossis koj cov ntaub ntawv Excel loj, cov txheej txheem upload yuav qeeb lossis txawm tias poob.
Txoj kev 4. Tshem tawm Excel Spreadsheet Password nrog VBA Code
Txoj kev kawg peb yuav saib yog siv VBA code los qhib Excel daim ntawv nthuav qhia. Txoj kev no tsuas yog ua haujlwm rau Excel 2010, 2007, thiab cov ntawv ua ntej. Nws yog ib qho tseem ceeb kom nco ntsoov tias txoj kev no tsuas tuaj yeem tshem tus password ntawm daim ntawv ua haujlwm. Txoj kev qhib lub xauv yog qhov nyuaj, yog li cov kauj ruam hauv qab no yuav pab tau.
Kauj ruam 1 : Qhib lo lus zais tiv thaiv Excel spreadsheet nrog MS Excel. Nias "Alt+F11" kom qhib lub qhov rais VBA.
Kauj ruam 2 : Nyem "Insert" thiab xaiv "Module" los ntawm cov kev xaiv.
Kauj ruam 3 : Sau cov cai hauv qab no hauv lub qhov rais tshiab.
Sub PasswordBreaker()
'Breaks worksheet password protection.
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 Error Resume Next
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
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 "One 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: Next: Next: Next: Next: Next
End Sub
Kauj ruam 4 : Nias F5 kom ua tiav cov lus txib.
Kauj ruam 5 : Nyob ib pliag. Lub dialog box tshiab yuav tshwm sim nrog tus password siv tau. Nyem "OK" thiab tom qab ntawd kaw lub qhov rais VBA.
Kauj ruam 6 : Rov qab mus rau koj daim ntawv teev kev tiv thaiv Excel. Tam sim no, koj yuav pom tias daim ntawv ua haujlwm raug kuaj xyuas.
Cons ntawm txoj kev no:
- Yog tias muaj ntau daim ntawv ua haujlwm tiv thaiv tus password hauv koj Excel, koj yuav tsum rov ua cov kauj ruam saum toj no rau txhua daim ntawv ua haujlwm.
Xaus
Tshem tawm tus password los ntawm Excel daim ntawv tsis tas yuav nyuaj. Nrog rau qhov ceev tshaj plaws rov qab ceev, ntau hom kev tawm tsam thiab tus nqi rov qab ntau dua, Passper rau Excel nthuav tawm qhov kev xaiv zoo tshaj plaws kom tshem tawm tus password sai sai ntawm txhua daim ntawv Excel.
![Yuav ua li cas tshem Password ntawm Excel VBA Project [4 Txoj Kev]](https://www.passmapa.com/images/desbloquear-proyecto-vba-excel-390x220.png)