![](/uploads/1/2/5/7/125778590/160809056.png)
I need help with password retrieval or bypassing the password on a project that was done at work. The author has used MS Excel to do the project, and it's in the client's server. The server that we use has no access to Notepad++.
user365483user365483
The SysInfo VBA Password Recovery tool lets you recover the lost or forgotten password of VBA projects in just a few clicks. Sometimes, this happens when you try to open basic visual files and are unable to access them due to the input of a wrong password. VBA password unlocker tool is the best solution to remove multilingual password (alphabets, numbers, special characters) from VBA workbook. View VBA Project Password Removal Details Once VBA file is added to the software, it shows you the complete details of recovery which includes the password removal procedure and generate new password.
1 Answer
For older .XLS files:
- Open file in any hex editor
- Search for the text 'DPB=' (no quotes, you should find it just above '[Host Extender Info]'
- Change it to 'DPx=', save and close the file
- Open the file in Excel and press Yes if the following warning pops up:
- Open the VBA editor (Alt+F11) and press OK whenever the following warning pops up:
- Right-click the VBA project name, select Properties, go to the Protection tab and delete the existing passwords as well as uncheck the Lock project for viewing checkbox:
- Re-check the Lock project for viewing checkbox and add your own memorable password.
- OK your way out and now the VBA code is accessible!
![Excel password breaker vba code Excel password breaker vba code](http://www.rixler.com/var/plain_site/storage/images/vba-scr-new/296054-1-rus-RU/vba-scr-new.jpg)
For newer .XLSM files:
- Change the file's extension to .ZIP
- Open the file in any archiver such as WinRAR or 7-Zip and you'll see the following directory structure:
- Go into the xl directory and extract vbaProject.bin:
- Perform steps #1-3 above (from the For older .XLS files section) with vbaProject.bin
- Replace the old vbaProject.bin in the ZIP file with the new hex edited version
- Change the file's extension back to .XLSM
- Perform steps #4-7 above
KaranKaran
protected by Community♦Mar 31 '15 at 19:16
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?
Would you like to answer one of these unanswered questions instead?
Not the answer you're looking for? Browse other questions tagged microsoft-excelvbapassword-recovery or ask your own question.
Remove VBA Password is a simple, yet powerful tool that can instantly remove any VBA passwords* and can unlock locked VBA projects in almost any type of file. It supports an extensive array** of applications including Microsoft Office (Excel, Word, PowerPoint, Access, Publisher, Outlook, FrontPage), MS Project and most other Microsoft products. It supports Autodesk AutoCAD, Bentley MicroStation and other CAD/CAM applications, other Office software packages, and various GIS, OCR, drawing and other VBA enabled applications.
Key features include:
- Passwords of any length and character set are supported and removed in seconds.
- Intentionally or accidentally locked VBA projects are unlocked instantly.
- Secure password removal without damages to the file + automatic backup.
- Support for Office 97 to 2013 and 365 file formats of all supported VBA host applications.
- Supports all MS Windows platforms including Windows 10.
- Supports command-line usage for custom scripting. (Pro edition only).
Passwords of any length and character set are supported and removed in seconds. Intentionally or accidentally locked VBA projects are also supported. Overall, Remove VBA Password is a great tool that does exactly what it says on the tin. It is lightweight, powerful and has a simple interface.
*The trial version has limitations: it only tests if the full edition can remove the password/lock.
**MS Excel 5.0, 7.0 and 95 XLA add-ins are not supported.
![](/uploads/1/2/5/7/125778590/160809056.png)