ANmarS - Blog

Excel/VBA expert since Sep 1997 (20 years 1 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

Easiest way to unprotect Workbook or Worksheet without password

Tue
Oct 25
2016

Looks like there is a bug in new Excel dealing with old Excel files
Tried 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
Tuesday Oct, 25, 2016 8:40
cybersecurity excel linkedin pc programming protection