loading
1Instructables25,478Views12 Comments

Tell us about yourself!

Complete Your Profile

Achievements

10K+ Views Earned a bronze medal
Show 0 More »
  • ruudslaats commented on syfrog's instructable VBA Code To Unlock A Locked Excel Sheet8 months ago
    VBA Code To Unlock A Locked Excel Sheet

    Unprotect Excel sheet without password using 7-ZIPThis way only works for Excel file in .xlsx format. Hence, if your Excel workbook is in .xls format, just open it and then save it as .xlsx format.Step 1: Change the Excel file name extension from .xlsx to .zip. Just click on Yes to make sure when prompted.Step 2: Open the ZIP archive as 7-ZIP. Open the folder xl->worksheets and you can see threesheet.xml files. Select the sheet1.xml file. Right click on it and select Edit. Choose to open it withNotepad.Step 3: Delete the tag beginning with sheetProtection. Then save and close the sheet1.xml file.Step 4: Update the modified sheet1.xml file in the ZIP archive when prompted. Then close the ZIP archive.Step 5: Change the ZIP fie name extension back to .xlsx. At this point, the Excel shee...see more »Unprotect Excel sheet without password using 7-ZIPThis way only works for Excel file in .xlsx format. Hence, if your Excel workbook is in .xls format, just open it and then save it as .xlsx format.Step 1: Change the Excel file name extension from .xlsx to .zip. Just click on Yes to make sure when prompted.Step 2: Open the ZIP archive as 7-ZIP. Open the folder xl->worksheets and you can see threesheet.xml files. Select the sheet1.xml file. Right click on it and select Edit. Choose to open it withNotepad.Step 3: Delete the tag beginning with sheetProtection. Then save and close the sheet1.xml file.Step 4: Update the modified sheet1.xml file in the ZIP archive when prompted. Then close the ZIP archive.Step 5: Change the ZIP fie name extension back to .xlsx. At this point, the Excel sheet has been unprotected. Open it and you can edit the sheet without password.

    View Instructable »