— iIT-Services

Archive
Tag "Script"

As written a while ago already, password-protected Excel worksheets can be unlocked through a VBA script:

Even more simple is the approach through editing the XML source of the Excel file, as described by paracon.ca/…:

  1. Rename your file by adding *.zip to its extension.
  2. Open the zip file.
  3. Browse to the path ‘xl > worksheets’ folder.
  4. Extract the protected sheet xml file to local drive.
  5. Open the xml and delete the markup text <sheetProtection …>.
  6. Save and close the xml file.
  7. Overwrite the original xml in the zip folder with the file from local drive.
  8. Close the zip file and rename the file by removing the .zip extension.
Read More