![]() ![]() Also you would be getting a message in the pop up window. MsgBox “One usable password is ” & Chr(i) & Chr(j) & _Ĭhr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _Ĭhr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)Īnd there you go the sheet is unprotected for you now. If ActiveSheet.ProtectContents = False Then Do not change the code just copy paste:ĭim i As Integer, j As Integer, k As Integerĭim l As Integer, m As Integer, n As Integerĭim i1 As Integer, i2 As Integer, i3 As Integerĭim i4 As Integer, i5 As Integer, i6 As Integerįor i = 65 To 66: For j = 65 To 66: For k = 65 To 66įor l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66įor i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66įor i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126ĪctiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _Ĭhr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _ or Sheet Name which you want to un-protect and then In the Above White Space Enter the below Code (In Italics). Press ALT + F11 or click on View Code in Developers TabsĬhoose the Sheet No. If you do not Remember the Password or do not know the password to unprotect the sheet just follow the below simple steps. In case of a password protect worksheet you are unable to Edit the data on the Excel Sheet. This document will tel you how to unprotect an excel spread sheet without having the password. Sometimes we need to change the content of the file to suit our requirements but we will not be able to make the changes if the excel sheet is password protected. ![]() ![]() Sheets of which are password protected by the author of the file. We many times receives excel files from various sources. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |