How to Recover a VBA Excel Password

Written by stephanie ellen
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Recover a VBA Excel Password
Unlock your VBA password with software. (llaves image by Leonardo Jerez from

Visual Basic for Applications (VBA) is a programming language used to customise 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.

Skill level:

Things you need

  • Atomic Visual Basic for Applications
  • VBA Password
  • Advanced VBA Password Recovery

Show MoreHide


  1. 1

    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.

  2. 2

    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.

  3. 3

    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 utilising 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.

Tips and warnings

  • Check the software for compatibility with your operating system and your version of Microsoft Office: some software may not work in all environments and for all versions of Excel. For example, AVPR will not work with Excel 2007 and Excel 2010.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.