In addition, I repeat what I said earlier: have you searched the community yourself? A good IT pro doesn't need to be spoon fed, they do their own legwork when a job needs to be done. Opening with OpenOffice or LibreOffice, or purchasing and downloading a password cracking tool. I believe the first 5 posts in that thread (and quite possibly others on the following pages) are viable strategies for a locked workbook.

If the WORKBOOK is protected you cannot paste any code in the VBA Code Editor. First of thanks for the link but even though the title of that thread says 'need to unlock a password protected Excel 2010 workbook' however all the answers posted on that thread are to unlock WORKSHEET.įor example, clicked on that link and scroll down to the post by 'oilfieldlady at 3:25 PM'. This thread has suggestions for both a locked workbook and locked worksheet I shall leave it to you to sort out which options you can try for yourself:

Have you perhaps tried to search the Community for an answer? I think the title of this thread should be changed to 'How to open or remove password protect excel worksheet (NOT WORKBOOK)?'.Īnyone has any ideas how to open or remove a password protect Excel WORKBOOK ?

Open office password cracker