Unprotect multiple workbook has same password & different password

[Alzakias]

Hello ,
I have lot of files , are protected , is there a way to unprotect all of them in one time ,
( some of them has same password ) (some has different ) , i have the password for some of them ) like 7b7b1b3b5b5b5
Thank you

 

[LostBees]

They would all need to have the same password then you can add a VBA to unprotect all the sheets within the workbook at once using the password

Sub unprotect_all_sheets()
On Error Goto blah
unpass = InputBox("Please enter the password:")
For Each Worksheet In ActiveWorkbook.Worksheets
Worksheet.Unprotect Password:=unpass
Next
Exit Sub
blah: MsgBox "There is s problem - check your password, capslock, etc."
End Sub

Will bring up a box for you to type the password into it to unprotect all sheets in the workbook

 

[Alzakias]

Thank you , its give me an error in first line

 

[Peter_SSs]

i have the password for some of them ) like 7b7b1b3b5b5b5

Are you therefore saying that you do not have the password for some of them?

 

[Alzakias]

I have it for all
7b7b5b1b3b5b5b5

 

[Peter_SSs]

( some of them has same password ) (some has different )

I have it for all
7b7b5b1b3b5b5b5

These two statements do not seem to agree

 

[Alzakias]

I want to unprotect all the multiple workbooks and worksheet's has the same password 7b7b1b3b5b5b5

 

[noveske]

I want to unprotect all the multiple workbooks and worksheet's has the same password 7b7b1b3b5b5b5

So it's the workbooks that don't all have the same password, but all the worksheets have the same password?

 

[Alzakias]

Both has same password