Visual Basic for Applications (VBA) is a programming language used to customize Microsoft Office applications. You can use VBA to create macros—short pieces of executable code—that can tailor Excel to fit your needs. If someone else has access to your files you may want to place a VBA password on the file to protect your code. However, if you lose the password, Microsoft will not help you to recover the lost password: your only option is use third party software to crack the password.
Navigate to the A Pass Cracker Atomic Visual Basic for Applications (AVBA) link (see Resources). AVBA recovers passwords for VBA passwords associated with Microsoft Excel and Word. The software promises to recover passwords instantly regardless of length. Although there is a trial version of the software available, it will only show the first two symbols of the cracked password: you must purchase the full version to see the rest of the password.
Click on Last Bit's VBA Password link (see Resources) and download the software. VBA Password uses a combination of six different techniques to crack your password, including dictionary attack which tries to match your password against every word in the dictionary. The software uses brute force (trying every possible character and letter combination) to recover some passwords; this process may take days so you can choose to reset the password instantly for access. VBA password works with all versions of Excel.
Navigate to Elcomsoft'sAdvanced VBA Password Recovery (AVPR) website (see Resources). AVPR can help you to recover Excel VBA passwords from Excel 97, 2000, XP, 2003. The software can also find the password for any Excel add-ins. The software works by utilizing the "backdoor" method which bypasses the password and recovers the file. Download the trial version of the software and use it free for 30 days. The trial version is limited to cracking passwords of 3 letters or less.