 –> (Word) |  –> (PDF) |  –> (Epub) |  –> (Text) |
 –> (XML) |  –> (OpenOffice) |  –> (XPS) | |
| This article has been published 1 year, 60 days ago | |||
| The estimated time to read this article is 4 minutes | |||
A VBA Project password can be removed with a hex editor (I used the XVI32 Freeware editor from here). Although I didn’t discover this method, I’m happy to post the process with screenshots to help others.
Sometimes all we need is that little snippet of code in an old VBA Project we’ve archived away…Open your chosen workbook file (.xls or .xla file) in the hex editor. It will look like the following;
Now search for the Text string "DPB" and change it to "DPx" (simply type over the value).
- Save the file over the top of the existing workbook and close.
- Now, open the workbook in Excel and click OK until the workbook is open (you may receive a couple of VBA errors on the way).
- Press ALT+F11 to open the Visual Basic Project window, from the Tools menu, choose the command VBAProject Properties, navigate to the Protection tab, and change the password but do not remove it (note the new password).
- Save the workbook, close, and re-open.
- Once open, press ALT+F11 and enter the new password.
- Finally, choose Tools -> VBAProject Properties, navigate to the Protection tab, and remove the password.
- Save the workbook.
SOURCE | LINK (Posterous.com)
| LANGUAGE | ENGLISH |
 |  | ||
Hello! Certainly you don't know us....we're a crew of computer's enthusiast, but we know that there're a lot of people searching constantly answers for their everyday problems with technology and computers, but we know also that there are people searching for answers, on web, for their everyday problems but NOT with technology, but for anything else. So, OUR first goal will be to give you quality answers to questions already done on web (forums, personal blogs, etc.), collect them and present them to you, integrating them if necessary, on this portal. Obviously, we will give you links to the source of these answers, giving, at the same time, credits to his author/site. We want to be your safe haven to your answers.
