1. Create a new simple excel file.
2. In the VBA part, set a simple password (say - 1234).
3. Save the file and exit.
4. Open the file you just created with a simple editor.
5. Copy the lines starting with the following keys:

CMG=....
DPB=...
GC=...

6. with a simple editor (again), open the excel file you don;t know
the VBA password for,
and paste the above copied lines from the dummy file.
7. save the excel file and exit.
8. Now, open the excel file you need to see the VBA code in. The
password for the VBA code
will simply be 1234 .

Please note the simple editor should be Hexa-decimal notepad. -----------------------------------------------------------------------------

If U can't have it working this way, then go for the paid software below...

VBA Password Recovery Master

Overview

VBA Password Recovery Master ensures that your VBA projects are accessible at all times despite everything. Whether a loss or unexpected change of a password occurred to VBA projects in Microsoft Word, Excel or Outlook, users can be sure of the projects’ accessibility. The program swiftly recovers vba passwords of any length and complexity. You can always rely on its expert knowledge of MS Office protection and secure access to VBA projects.

The program does all the work of password recovery in the automatic mode. The only thing it needs from the user is the location of the protected file. Upon recovery, the user gets a password that opens their VBA project and makes the source code accessible again. Now with a single mouse click you can copy the password to the clipboard and store in a safe place. The reliable and robust recovery engine, ease of use and clear interface make VBA Password Recovery Master an ideal tool to solve VBA project accessibility problems.

Features and benefits

• Recovers VBA password for Microsoft Word, Excel and Outlook files.

• Supports all versions of Microsoft Word, Excel and Outlook.

• Instant recovery of vba passwords of any length and complexity.

• Allows to copy recovered vba password to the clipboard.

• Simple and intuitive interface.

User interface

VBA Password Recovery Master automatically recovers VBA password when you open the file containing password protected VBA project. To open the document, click on the icon on the right part of the program window and indicate the required file.

System requirements

• Windows 9x / ME / NT / 2000 / XP / 2003.

• The program supports all versions of Microsoft Word, Excel and Outlook.

(US $19.95)
Secure Processing
Immediate Download