ANmarS - Search results

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

We are moving ...

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

1 Blog posts tagged with protection


Tue
Oct 25
2016

Easiest way to unprotect Workbook or Worksheet without password


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
Read more >>>

Tuesday Oct, 25, 2016 8:40