3 Txoj hauv kev los tiv thaiv daim ntawv Excel ua haujlwm

2024 Tus sau: Jason Gerald | [email protected]. Kawg hloov kho: 2024-02-02 14:56

Qhov wikiHow qhia koj li cas tshem kev tiv thaiv los ntawm daim ntawv ua haujlwm hauv Microsoft Excel ntawv lossis phau ntawv ua haujlwm ntawm Windows lossis macOS computer. Yog tias daim ntawv tau tiv thaiv tus password thiab koj tsis paub nws, siv Google Cov Ntawv lossis VBA cov lus txib (nyob rau yav dhau los ntawm Excel) kom tshem kev tiv thaiv.

Kauj ruam

Txoj Kev 1 ntawm 3: Siv Microsoft Excel

Kauj Ruam 1. Qhib daim ntawv lossis phau ntawv ua haujlwm nrog daim ntawv tiv thaiv hauv Microsoft Excel

Koj tuaj yeem qhib nws los ntawm ob-nias lub npe cov ntaub ntawv ntawm koj lub computer.

Kauj Ruam 2. Txoj cai-nias ntawm daim ntawv ua haujlwm tiv thaiv tab

Txhua daim ntawv tab yog nyob hauv qab ntawm lub qhov rais Excel. Cov ntawv tiv thaiv feem ntau yog cim los ntawm lub cim ntsuas phoo hauv qee qhov qauv ntawm Excel. Right-click lub tab (lossis xauv lub cim) kom qhib cov ntawv qhia zaub mov.

Yog tias muaj ntau daim ntawv raug tiv thaiv, koj yuav tsum tshem kev tiv thaiv rau txhua daim ntawv ib tus zuj zus

Kauj Ruam 3. Nyem Unprotect Sheet

Yog tias nws tsis tiv thaiv tus password, daim ntawv yuav qhib tam sim. Txwv tsis pub, koj yuav raug nug kom nkag mus rau koj tus password hauv lub qhov rai qhib.

Kauj Ruam 4. Sau tus password thiab nyem OK

Yog tias lo lus zais raug, daim ntawv tiv thaiv yuav qhib.

Yog tias koj tsis paub tus lej twg nkag mus, nyeem cov hau kev rau kev xa mus rau Google Cov Ntawv. Txoj hauv kev no tso cai rau koj rub cov ntawv xa mus rau Google Cov Ntawv kom tag nrho cov kev tiv thaiv uas tau thov rau daim ntawv tuaj yeem qhib tau.
Yog tias koj siv Excel 2010 lossis cov ntawv ua ntej thiab tsis xav upload cov ntawv rau Google Sheets, nyeem cov hau kev rau siv VBA code hauv Excel 2010 thiab cov ntawv ua ntej.

Txoj Kev 2 ntawm 3: Tshaj Tawm Cov Ntaub Ntawv rau Google Cov Ntawv

Kauj Ruam 1. Mus ntsib https://drive.google.com ntawm lub vev xaib

Yog tias koj muaj Google tus lej, koj tuaj yeem siv Google Sheets cov kev pabcuam (daim ntawv thov online dawb zoo ib yam li Excel) tshem tawm kev tiv thaiv ntawm txhua nplooj ntawv hauv Excel daim ntawv lossis phau ntawv ua haujlwm, txawm tias thaum koj tsis paub tus password nkag mus.

Yog tias koj tseem tsis tau kos npe rau hauv koj tus lej Google tseem, ua raws cov lus qhia ntawm lub vijtsam kom nkag mus rau koj tus lej nyiaj.
Yog tias koj tsis muaj Google account, nyeem kab lus yuav ua li cas thiaj tsim tau Google account.

Kauj ruam 2. Nyem + Tshiab

Nws nyob rau sab saum toj-sab laug ntawm qhov screen.

Kauj Ruam 3. Nyem File Upload

Lub vaj huam sib luag "Qhib" ntawm lub computer yuav tshwm.

Kauj Ruam 4. Xaiv Excel cov ntaub ntawv koj xav kho thiab nyem Qhib

Cov ntawv yuav raug xa mus rau koj tus lej Google Drive.

Kauj Ruam 5. Nyem ob npaug rau Excel cov ntaub ntawv hauv Google Drive

Tej zaum koj yuav tsum tau xaub hla lub vijtsam kom pom cov ntawv. Lub qhov rai saib ua ntej cov ntaub ntawv yuav qhib tom qab ntawd.

Kauj Ruam 6. Nyem Qhib nrog cov ntawv qhia zaub mov

Cov ntawv qhia zaub mov no yog nyob rau sab saum toj ntawm lub qhov rai saib ua ntej. Tom qab ntawd, cov ntawv qhia zaub mov yuav nthuav dav.

Kauj Ruam 7. Nyem Google Ntawv

Thaum cov ntaub ntawv tau qhib thiab npaj yuav raug kho ntawm Google Sheets, kev tiv thaiv thov rau cov ntawv yuav raug tshem tawm.

Kauj Ruam 8. Rub tawm cov ntawv rov qab mus rau lub khoos phis tawj

Yog tias koj xav txuas ntxiv ua haujlwm hauv Microsoft Excel, thiab tsis yog hauv Google Ntawv, rub tawm qhov tshiab, tsis muaj kev tiv thaiv nrog cov kauj ruam no:

Nyem cov ntawv qhia zaub mov " Cov ntaub ntawv "Nyob rau sab saud sab laug ntawm daim ntawv.
Nyem " Download Raws li ”.
Nyem " Microsoft Excel (.xlsx) ”.
Xaiv cov ntaub ntawv khaws cia. Yog tias koj xav khaws cov ntawv qub ntawm cov ntawv (tiv thaiv version), ntaus lub npe tshiab rau cov ntawv yuav tsum rub tawm.
Nyem " Txuag "Los rub tawm cov ntawv.

Txoj Kev 3 ntawm 3: Siv VBA Code hauv Excel 2010 thiab Cov Laus Laus

Kauj Ruam 1. Qhib daim ntawv lossis phau ntawv ua haujlwm nrog daim ntawv tiv thaiv hauv Excel

Koj tuaj yeem nyem ob npaug rau lub npe ntawm koj lub computer. Cov ntaub ntawv Excel feem ntau xaus nrog.xls lossis.xlsx txuas ntxiv.

Siv txoj hauv kev no yog tias koj tau sim tshem daim ntawv tiv thaiv, tab sis cov ntaub ntawv uas twb muaj lawm tau tiv thaiv los ntawm tus password (thiab koj tsis paub tus password).
Txoj kev no tsis tuaj yeem ua raws hauv Microsoft Excel 2013 lossis tom qab hloov tshiab.

Kauj Ruam 2. Txuag cov ntaub ntawv dua hauv xls hom

Yog tias cov ntaub ntawv muaj tam sim no muaj ".xlsx" txuas ntxiv (ib qho txuas ntxiv rau cov ntaub ntawv tsim lossis kho siv yav tom ntej ntawm Excel), koj tsuas tuaj yeem siv txoj hauv kev no yog tias koj xub hloov cov ntaub ntawv rau Excel 97-2003 hom (.xls). Nov yog yuav hloov cov ntawv rau hom ntawv li cas:

Nyem cov ntawv qhia zaub mov " Cov ntaub ntawv "Nyob rau sab xis sab xis ntawm qhov screen.
Nyem " Txuag As ”.
Mus rau daim nplaub tshev uas cov ntawv tau txais kev cawmdim.
Xaiv " Excel 97-2003 (.xls) "Los ntawm" Txuag raws li hom "lossis" Hom Ntawv "cov ntawv qhia zaub mov.
Nyem " Txuag ”.

Ua raws cov lus qhia ntawm lub vijtsam kom hloov pauv qhov tsim nyog.

Kauj Ruam 3. Nias Alt+F11 kom qhib qhov Visual Basic Editor window

Kauj Ruam 4. Txoj cai-nias lub npe cov ntaub ntawv hauv "Project-VBAProject" pane

Lub npe cov ntaub ntawv yog nyob rau sab saum toj ntawm sab laug pane. Nco ntsoov koj nyem txoj cai xaiv uas muaj cov ntaub ntawv npe (xaus nrog ".xls" txuas ntxiv) uas feem ntau yog nyob rau saum. Tom qab ntawd, cov ntawv qhia zaub mov yuav nthuav dav.

Kauj Ruam 5. Nyem Ntxig rau ntawm cov ntawv qhia zaub mov

Tom qab ntawd, lwm cov ntawv qhia zaub mov yuav nthuav dav.

Kauj Ruam 6. Nyem Cov Qauv

Ib qho qauv tshiab yuav raug ntxig thiab tom qab ntawd, koj tuaj yeem muab cov lej tso rau hauv tus qauv.

Kauj Ruam 7. Luam cov cai

Nyeem cov cai hauv qab no, tom qab ntawd nias Ctrl+C (PC) lossis Command+C (Mac) kom luam nws:

Sub PasswordBreaker () Ua txhaum daim ntawv ua haujlwm tiv thaiv tus password. Dim li 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 Rov Mus Ntxiv Rau Kuv = 65 Rau 66: Rau j = 65 Rau 66: Rau k = 65 Rau 66 Rau l = 65 Rau 66: Rau m = 65 Rau 66: Rau i1 = 65 Rau 66 Rau i2 = 65 Rau 66: Rau i3 = 65 txog 66: Rau i4 = 65 txog 66 Rau i5 = 65 txog 66: Rau i6 = 65 txog 66: Rau n = 32 Rau 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) Yog ActiveSheet. ProtectContents = Cuav Ces MsgBox "Lo lus zais yog" & Chr (i) & Chr (j) & _ Chr (k) & Chr (l) & Chr (m) & Chr (i1) & Chr (i2) & _ Chr (i3) & Chr (i4) & Chr (i5) & Chr (i6) & Chr (n) Tawm Sub End Yog Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej kawg




6297644 20

Kauj Ruam 8. Right-click tus qauv tshiab thiab xaiv Paste
Cov cai theej theej tawm yuav tshwm nyob rau hauv lub qhov rai module.



6297644 21

Kauj Ruam 9. Nias F5 qhov tseem ceeb kom ua raws txoj cai
Excel yuav khiav cov cai thiab cov txheej txheem no yuav siv ob peb feeb. Thaum cov cai tau ua tiav, tus password tshiab yuav tshwm nyob rau hauv lub qhov rai pop-up.
Tus lej tshiab yuav suav nrog tus lej "A" uas tsis yog tus lej thawj



6297644 22

Kauj Ruam 10. Nyem OK ntawm qhov "Password" pop-up window
Tus lej tshiab yuav tshwm, tab sis koj tsis tas yuav sau nws. Nyem " OK "Kom tshem kev tiv thaiv ntawm daim ntawv ua haujlwm cia.