Protection Removal

[dezian]

I've just inherited some excel files to amend and update, the problem arises when I try to change any of these files as they are password protected and have all the code hidden. What I would like help with is either removing the protection or unhide the code so I can save it as something else without the protection? Any takers.

Your help will be most appreciated.

Cheers Andy Hickson

 

[Bowers74]

Unless you know the password, you won't have much luck.

If you do know the password, and it is the same for the protection on all of the sheets, you could use the following procedure:

Sub Unprotect_All()
Dim ws as Worksheet
On Error Resume Next
For Each ws in ThisWorkbook.Worksheets
ws.Unprotect "YourPasswordHere"
Next ws
On Error Goto 0
End Sub

I hope this helps!

P.S. If you don't know the passwords, then you need to do a web search for Password Recovery programs (there are a lot of them out there).



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!