This code below will remove your spreadsheet password for any files from Excel 2003 to Excel 2010.
For more including removing the password from Excel 2016/2013 please visit http://bit.ly/2dlx8iN.
Paste the below code in any module or any VBA Workbook Project and run the code. This only works for Excel 2010 and below versions.
For more including removing the password from Excel 2016/2013 please visit http://bit.ly/2dlx8iN.
Paste the below code in any module or any VBA Workbook Project and run the code. This only works for Excel 2010 and below versions.
Reference for Office 365 Excel
Sub removeShPassword()
'-----------------------------
'Thanks for downloading the code.
'Please visit our channel for a quick explainer on this code.
'Feel free to update the code as per your need and also share with your friends.
'Channel: Youtube.com/vbaa2z
'Download free codes from http://vbaa2z.blogspot.com
'Autor: L Pamai (vbaa2z.team@gmail.com)
'-----------------------------
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
If Application.Version > 14 Then
MsgBox "Only for Excel 2010 and below versions."
Exit Sub
End If
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 removed!"
Exit Sub
End If
Next: Next: Next: Next: Next: Next:
Next: Next: Next: Next: Next: Next:
End Sub
No comments:
Post a Comment
Note: only a member of this blog may post a comment.