✅ 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://danetidwell.com
Xem thêm bài viết khác: https://danetidwell.com/giai-tri/
Xem thêm Bài Viết:
- Mì tôm TV nơi cập nhật những tin tức bóng đá nhanh chóng và chất lượng
- Review mẫu máy lọc rượu giá dưới 8 triệu đồng cho hộ kinh doanh nhỏ
- Sinh năm 1992 mệnh gì? Tuổi Nhâm Thân Hợp tuổi nào & Màu gì?
- Phần mềm quản lý bđs : Xu hướng mới trên thế giới
- Hướng dẫn cách chơi quay slot nổ hũ liên minh huyền thoại B52Club
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.
Thank you so much. This is by far the clearest explanation and worked to a T and on a Mac. Really really helpful.
Method 2 is my savior. You worth a lot more subscribers!
Method 3 saved my bacon. Very cool
I WANT WORKBOOK PASSWORD REMOVE PLS HELP
THanks mate!
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?
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.
Can i see the functions after we unlock the protected sheet as u said
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!
genius!
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.
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
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
method two is magic, thank you for the help!
I used the foolproof method and crashed my file. lost my job. lost my house. dog ran away. wasn't even my dog
Thank you sir!
Superb !
well holy shit. thank you 🙂 Liked the video. Appreciate it!
Thank you sir. It worked .
nice
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
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.
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!
hi, i cannot see the contents of zip file as you shown. what i am doing wrong. please help. thx
is there a way to protect vba without getting cracked?
DAAAAAAAMMMMNNNNN you're a beast!!!! feels great!
method 2 worked in less than a minute. Thankyou.
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.
Thank you very much. No. 3 works perfectly for me.
Thanks.
im just not able to do it can u please help me ….
At 8:32 I don’t have xml, I have .bin
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!
This worked, thank you so much!
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.
Hello there! It is so great. Can you share that code, Sub sbRemoveSheetPassword()?
para sa plate ni sir arkero hehehe
Va
Hi there, I am using excel 2010. The protected workbook for me troubling me a lot. I have seems multiple ways to unprotect it, but nothing worked. Basically, I am not getting the VBA code page for my file. Secondly if I try to unzip it, I get error as "No archive found" … I will be grateful, if you have any help ….
When i open the excel with 7zip it only has a folder and 2 items. Dataspaces, encryptedPackage and endryptioninfo
Hey there! It was a grt and very helpful, but can you also make a video to crack a password of encrypted workbook??
Hi.. love this.. especially method #1 which had not occurred to me previously and method #3 which I tried and it worked just as you demonstrated. Excellent! Is there anything similar that works at the workbook level? My guess is not.. but worth asking. Thanks for sharing these great tips. Thumbs up!