Search code examples
vbaexcelpassword-protection

How to unprotect an Excel workbook

I have an Excel workbook that is password protected (the entire document, not just a sheet or set of sheets - you can't open the file without the password). I know the password, so I am able to open it, but there is no obvious way to turn off the password protection.

Specifically, I would like to do this in VBA, because eventually I want to be able to do this to multiple files using a loop. I tried using:

ThisWorkbook.Unprotect(Password = "[password]")

but this does absolutely nothing.

Solution

  • If it's the password to open the file, you want:

    Thisworkbook.Password = ""

    then save it.

    Wb.Unprotect would remove the password that protects the workbook structure/windows.