Need help writing code to unprotect multiple WBs with same password

Hi there,

Second time posting this here because it's been over a week with no replies on the first, I am wondering if there is a way to mass-unprotect multiple workbooks at once. I basically have one directory, and all of the individual .xlsm files are in there. There are around 400 individual workbooks, some of which are protected, while others are not. Of the ones that are protected, all of them have the same password. Can someone help me figure out a way to unprotect all of them at once? I am still really new to VBA, so a breakdown of what's going on in the code comments would be really nice too.

Thank you!

you probably can't. you have to be inside a book to issue the transaction you're talking about.

I have to disagree with. We can write code in a workbook that is placed in the directory and execute that code. I'm working on a solution.

Originally Posted by maniacb

I have to disagree with. We can write code in a workbook that is placed in the directory and execute that code. I'm working on a solution.

are you talking to me? if so, I didn't understand anything you said.

Sorry vba_php, I now realize that Rory's answer need to be answered first. my bad.

Here is what I was thinking could work, but it depends on the type of protection, and if there are multiple sheets.

Please Login or Register  to view this content.