Buzz
This guide strongly discourages attempting to unlock passwords of Excel 2016 files related to others' privacy. The article aims to support users who have unfortunately forgotten the passwords they set for their own Excel 2016 files.
Step-by-step Guide to Unlocking Excel 2016 Passwords
Unlocking Excel 2016 Passwords
To break the password of an Excel file in Excel 2016, follow the steps outlined below:
Step 1: Open the Excel file containing the protected sheet. Due to the password, you cannot Copy, Cut, or perform any actions on the sheet in use. When attempting any operation, a notification like the one below will appear:
Step 2: Click OK to close the window in Step 1. Press and hold ALT + F11 (on some laptops, it might be ALT + Fn + F11) to open Microsoft Visual Basic:
Step 3: Double-click on the Sheet you want to unlock. If you don't see the Sheets on the left side of the screen, you can press the key combination Ctrl + R to display them.
Step 4: Copy the VBA code below:
Sub PasswordBreaker()
If ActiveSheet.ProtectContents = False Then
MsgBox 'Sheet '' & ActiveSheet.Name & '' is unprotected!', vbInformation
Else
If MsgBox('Sheet '' & ActiveSheet.Name & '' is protected, do you want to unprotect it?', _
vbYesNo + vbQuestion, 'Unprotect Active Sheet') = vbNo Then Exit Sub
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 To 65 To 66
Next, paste it into the newly appeared window -> then, select the Run menu ->click on Run Sub/UserForm (or press the shortcut key F5).
Step 5: The confirmation dialog Unprotect Active Sheet will appear -> press Yes to confirm the continuation of the process.
Step 6: Wait for a moment as the application automatically breaks the password to help you. Upon successfully breaking the password, the application will display a notification as shown below:
So, you've just successfully Unlocked Excel 2016 Password. The steps for you to follow are quite simple and not challenging at all. With this method, you won't have to spend additional time searching for specialized applications or software to break the password for your Excel file.
If you are using a different version of Excel such as Excel 2013, Excel 2010, 2007, or 2003, check out the tips on breaking Excel passwords on Excel 2013, 2010, 2007, 2003 that Mytour has shared. Good luck!
