3 Ways To Unprotect Excel Sheets: Crack AND Restore Unknown Passwords



✅ Download Practice Workbook: »»
Remove Excel sheet protection and add it back again…..all without even knowing the password. In this video I’ll show you 3 ways to crack password protection on Excel sheets and re-protect them afterwards.

👨‍🏫 Remove On-Screen Tutor: »»

======================================================================================
🕑 Video Timings and Methods Used:
00:00 Overview of Methods
00:50 Method 1: Get Lucky – find it within existing VBA code
02:50 Method 2: Remove with a VBA macro – can’t restore the password after
06:44 Method 3: Hack the File Code – Fastest and most likely to work, but most advanced

======================================================================================
You will learn how to unprotect an Excel sheet without knowing the password in 3 different ways with this video. You can remove an Excel password without software as long as the file is not encrypted. Learning how to unprotect an Excel sheet can be as straight forward as using the toolbar command to unlock protected Excel sheets without passwords. If there is a password, you will want an Excel password remover- without any application – in order to crack Excel sheets. I will show you 3 ways how to unprotect Excel sheets without the password and thereby remove Excel password protection. When you see how to unlock protected Excel sheets without the password you can regain control of spreadsheets with forgotten Excel passwords. You do not need an Excel password cracker to unprotect Excel cells without the password, because when you remove Excel protection without software you will unlock the Excel spreadsheet, unprotect the sheet in Excel and unlock cells all at once.

I show you how to unprotect excel sheets in 3 ways. It’s the same as having an excel password remover- without any application. Yes, remove excel password without software and unprotect sheet. When you know how to unprotect excel sheet without knowing password you can crack excel sheets, remove excel protection without software, and unlock protected excel sheets without password. This video shows how to unprotect excel sheet in windows 10 but works exactly the same in all versions of windows. Unlock your excel spreadsheet now with this video showing how to unprotect excel sheet without password.

======================================================================================
VBA Code to Unprotect in Method 2 (If you need to restore the password use Method 3)
Code contained in practice workbook module 1:
Code not written by myself so use at your own risk. I have simply broken out onto separate lines to allow it to be run one loop at a time with stop breaks to avoid machine lockups.

Sub sbRemoveSheetPassword()

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 “Complete”
Exit Sub
End If

Next
Next
Next
Next
Next
Next
Next
Next
Next
Next
Next
Next

End Sub

======================================================================================
#Up4Excel
#Up4ExcelAdvanced
#Up4ExcelTips

Here at Up4Excel we’re on a mission to help YOU:
» Get your Excel skills UP and your task time DOWN
» Focus on shortcuts and fast impressive results
» Improve your productivity and free up your time

Everyone will assume you work 24 hours a day to produce the kind of output you’ll be producing in no time…. with the help of Up4Excel training.

We release multiple videos each week, packed full of ways to save time and impress those around you.
💎 Don’t miss out and fall behind…..
🅾 SUBSCRIBE NOW 🅾

======================================================================================
💥 Shortcuts Cheat Sheet: »»
📘 Dynamic Chart Template: »»
✅ Download Practice Workbook: »»

======================================================================================

Nguồn: https://buonhangthoitrang.com/

Xem thêm bài viết khác: https://buonhangthoitrang.com/tong-hop/

  • Remove Excel sheet protection and add it back again…..all without even knowing the password. In this video I'll show you 3 ways to crack password protection on Excel sheets. make the changes you want, and then re-protect the sheet again afterwards. I go through 3 methods, getting increasingly more sophisticated and more robust.

    Up4Excel June 23, 2020 8:12 am Reply
  • Thanks for method 2 it works you are great!

    Da Ly June 23, 2020 8:12 am Reply
  • Amazing!
    This is what I looking for.
    Method 3 works for me.
    Thank you very much.

    JIN Virtual June 23, 2020 8:12 am Reply
  • None of these worked for me? Especially the last one, whenever I open the .zip it only comes up with the encryption stuff?

    CJPython June 23, 2020 8:12 am Reply
  • awesome! – took barely a minute using method 2!!!

    Peter Richards June 23, 2020 8:12 am Reply
  • i like and subscribe because it work. Thanks

    Aldrine Paul Bornales June 23, 2020 8:12 am Reply
  • could you please explain the code which guess the password ?

    Mohamad June 23, 2020 8:12 am Reply
  • Thank you SIR,
    Your just amazing, I was searching to remove xls file protection from 2 days read several articles and go through vedios also but i will not succeed suddenly i found your video try first method doesn't work and used second method and its works.

    akshay G mukhekar June 23, 2020 8:12 am Reply
  • Last method was soooo easy, thanks dude! Never heard of the vba thing, that's why I went for number three

    Bror Tobias June 23, 2020 8:12 am Reply
  • how to unlock the whole workbook not only a sheet ?

    Mohamad June 23, 2020 8:12 am Reply
  • Thank you so much. This is by far the clearest explanation and worked to a T and on a Mac. Really really helpful.

    zipperdeedooha June 23, 2020 8:12 am Reply
  • Method 2 is my savior. You worth a lot more subscribers!

    Syarifah Mardhiah June 23, 2020 8:12 am Reply
  • Method 3 saved my bacon. Very cool

    Ian Dangerfield June 23, 2020 8:12 am Reply
  • I WANT WORKBOOK PASSWORD REMOVE PLS HELP

    Kacha Chandresh June 23, 2020 8:12 am Reply
  • THanks mate!

    Soban Ahmad June 23, 2020 8:12 am Reply
  • Hello, I canot add a sheet to insert vba code so I tried third method and removed lines as you advised but still password is not removed. As soon I click on file name in VBA editor it ask for password. Any help please?

    man pany June 23, 2020 8:12 am Reply
  • my excel file is getting corrupted if use method 3 as soon as i unzip and zip it. method 2 freeze the excel and i cant use F11 since it protected.

    Robin Poulose June 23, 2020 8:12 am Reply
  • Can i see the functions after we unlock the protected sheet as u said

    Muhammed Nizam June 23, 2020 8:12 am Reply
  • You're awesome! Tried the steps using other videos for xlsm and yours is the only one that worked! Method 3 is nice by the way. Thank you!

    Callcanterlife Mishmash June 23, 2020 8:12 am Reply
  • genius!

    stefano grita June 23, 2020 8:12 am Reply
  • Awesome. Thank´s a lot for the 3rd tip. Just a advice, some free compressing programs do not write it correctly when compacting the file again, causing the file to be "corrupt". The best way it´s to use Windows native compressing tool.

    Jose Henrique Santos June 23, 2020 8:12 am Reply
  • My Excel file had a password over it. I tried to try the zip method, but it is being corrupted. I used 7zip to open .zip contens, which delivered me a folder called 'Data Spaces' and two files namely 'encryption package' & 'encryption info'. have ben trying for a month. Its an important file. Please guide me further. @Up4Excel

    Martand Singh June 23, 2020 8:12 am Reply
  • Your video is educative and i have a password that i want to recovery i was unable to apply the methods on my excel protected sheet and would need your help

    Emmanuel Emumejakpo June 23, 2020 8:12 am Reply
  • method two is magic, thank you for the help!

    Ivan Larin June 23, 2020 8:12 am Reply
  • I used the foolproof method and crashed my file. lost my job. lost my house. dog ran away. wasn't even my dog

    smellycat249 June 23, 2020 8:12 am Reply
  • Thank you sir!

    Roberta Rodamilans June 23, 2020 8:12 am Reply
  • Superb !

    Jason Almeida June 23, 2020 8:12 am Reply
  • well holy shit. thank you 🙂 Liked the video. Appreciate it!

    SCENE June 23, 2020 8:12 am Reply
  • Thank you sir. It worked .

    AshFahim June 23, 2020 8:12 am Reply
  • nice

    Arief Hidayat June 23, 2020 8:12 am Reply
  • I tried method 3 and got stuck at opening up the xml file to notepad. For some reason the code turned into all symbols when I opened the xml in a notepad.. i'm not sure why

    Sarj Thiru June 23, 2020 8:12 am Reply
  • When I do method 3 in Excel on my mac, the file is corrupt "The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt." I don't get why it seems to work for some people and not others, since this and similar methods have never worked on my mac. I'm testing method 2, to see if it works. Right now it's running for a few minutes on my test sheet with a simple password to see if I can try it on a more complex worksheet. Thanks for the video.

    petlingo June 23, 2020 8:12 am Reply
  • No need for all these, just open the file using google sheets and all the vb code will be bi-passed then re save back to excel – done!

    Godfrey Kutumela June 23, 2020 8:12 am Reply
  • hi, i cannot see the contents of zip file as you shown. what i am doing wrong. please help. thx

    Ajay Mehta June 23, 2020 8:12 am Reply
  • is there a way to protect vba without getting cracked?

    Master Swordz June 23, 2020 8:12 am Reply
  • DAAAAAAAMMMMNNNNN you're a beast!!!! feels great!

    Sammie Aviya Kealoha Agnarsson June 23, 2020 8:12 am Reply
  • method 2 worked in less than a minute. Thankyou.

    mjseppo June 23, 2020 8:12 am Reply
  • Hello, you can watch this https://www.youtube.com/watch?v=w5Ek5B4qx_w software video to easily find out the lost password of Excel files download this tool to click here https://www.esofttools.com/excel-password-recovery.html and you can easily find out excel file password.

    I hope it's helpful for you.

    jon rink June 23, 2020 8:12 am Reply
  • Thank you very much. No. 3 works perfectly for me.

    bbb June 23, 2020 8:12 am Reply
  • Thanks.

    James Wilson June 23, 2020 8:12 am Reply
  • im just not able to do it can u please help me ….

    Sowmya Manchenalli Venkatesh June 23, 2020 8:12 am Reply
  • At 8:32 I don’t have xml, I have .bin

    J WALLOP June 23, 2020 8:12 am Reply
  • I had a couple very useful files that I wrote back in 2013 and could not remember some parameters. You saved me like a day of work. Thanks!

    Luis Fernando Gutiérrez Urzúa June 23, 2020 8:12 am Reply
  • This worked, thank you so much!

    Marina Nieto June 23, 2020 8:12 am Reply
  • Hi, Is not so good idea to show how to unprotected a spreadsheet. If I protected a file from GDPR reasons, or to protect my work, will be a disaster id someone will see your film and manage to unprotect. I am not agree to show a movie like this. I am very disappointed.

    aelus roxana June 23, 2020 8:12 am Reply

Leave a Reply

Your email address will not be published. Required fields are marked *