Easiest way to unprotect Workbook or Worksheet without password
Looks like there is a bug in new Excel dealing with old Excel filesTried that several times and it worked every time, it did actually remove the password for protected view of Worksheet and Workbook, it did not remove the protection, just the password.
So, If you have xlsx or xlsm with Workbook view or Worksheet view protected, do the following:
- Save it as xls
- Save it back as xlsx or xlsm
- Now try to unprotect workbook or worksheet
The password just, Gone! with the wind
Posted on Linkedin here
https://www.linkedin.com/pulse/easiest-way-unprotect-workbook-worksheet-without-password-amdeen
excel pc programming cybersecurity protection linkedin