Sub PasswordBreaker()ĭ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. You can edit any cells as soon as the Excel sheet is unprotected. Method 2: Go to the ' REVIEW' tab and click the ' Unprotect Sheet ' in the ' Changes ' group. Method 1: Right click the 'sheet' tab and then from the 'context menu', select the option of ' Unprotect Sheet '. May not be the most efficient answer to your question, but its a useful bit of code to have nonetheless. This can be done with the following two Methods. It takes a little time depending on the length of the password, but essentially it just sledgehammers its way through, and unlocks the worksheet. Now, hit the ‘ Insert ‘ button and the ‘ Module ‘ button from the menu. Right-click on the workbook name, this is a Project-VBA window. Now, press the ‘ ALT ‘ key and the ‘ F11 ‘ key to open the Visual Basic Editor. This will unlock any password protected worksheet. Launch the Excel Sheet that is protected by the password. I found some code a while back which may be of some help.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |