Made a VBA code to protect sheets... now I can't unprotect the sheets

So I have a workbook with many sheets and wanted to protect all of the sheets using VBA. So I found some code online to do this, and it worked, but now when I try to unlock any of the sheets it says the password is incorrect...

Here is the code...

Please Login or Register  to view this content.

So what is my password?

Originally Posted by Richard Buttrey

Presumably you're using 1234 as the password?

Upload the workbook so that we can see the problem in context.

Yes, I'm using 1234. Also tried any variation I can think of.

I cannot upload it due to it's proprietary nature. However, I've tried it in a brand new workbook and it has the same issue. You can paste the code above into a VBA module and try it out.

Your code, as posted, has an error.... parameters use := to define their values.

Please Login or Register  to view this content.

The code cannot run so makes me think that is not the code you have run... Try unprotecting with a blank password.

Thanks! Glad I can finally unprotect my sheets, phew!

However, it's strange that I can't manually unprotect the sheet by going through the Review tab.