How to Remove Password of an Excel File with VBA Code

Excel files often contain sensitive information that are password protected for security reasons. However, there may be situations where you need to remove the password from an Excel file using VBA code. Here's how you can do it:

1. Open the Excel file that is password protected.
2. Press Alt + F11 to open the Visual Basic for Applications (VBA) editor.
3. Insert a new module by clicking on 'Insert' and then 'Module'.
4. Copy and paste the following VBA code into the module:

Sub RemovePassword()
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 '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

5. Close the VBA editor and press Alt + F8.
6. Select 'RemovePassword' and click 'Run'.
7. A pop-up will display the password for the Excel file.
8. That's it! The password has been removed from the Excel file using VBA code.