VBA password

Solved
staouni -  
 prof excel -
Hello,
I lost the password for a macro
is there a way to recover it or remove it?
I found software that allows you to do this but they are not free
do you know of any free software that can do this knowing that I work with Excel 2003?

Please help me, I'm stuck.
Thanks
Configuration: Windows XP Internet Explorer 6.0

5 réponses

Mike-31 Posted messages 18405 Registration date   Status Contributeur Last intervention   5 146
 
Hello,

There are small utilities that allow you to remove certain passwords legally, as long as you do not infringe the confidentiality of the file, meaning you are the author, and the use is under certain conditions. It is out of the question to illegally crack a password. If that's the case, you can check out these sites:

http://fordom.free.fr/applications/DEPROTEGE.htm

http://www.01net.com/windows/Utilitaire/cryptage_et_securite/fiches/19792.html

See you!

__________________________________________________________________

Need help? On the forum, volunteers take the time to decrypt your sometimes confusing explanations and share their knowledge.
Once a solution is found, please have the courtesy to mark your status as resolved. This way, your problem can be categorized and serve as a reference for other similar cases.
3
utilisateur
 
Remove the protection from VBA code in Excel
First of all, the purpose of this post is not to make you a hacker. However, during a colleague's sudden departure on vacation, it may be necessary to access VBA code that is password protected. Here’s how to break this protection:

1. First, make a backup copy of the original document. You never know what might happen.

2. Open the XLS file with a hex editor (for example, Hex Editor)

3. Search for the string 'DPB' and replace it with 'DPx'

4. Save the file and reopen it in Excel

5. Excel will give various error messages that you can ignore and will eventually open the file correctly

6. Go to the VBA code editor (Alt+F11) and in the VBA project properties, go to the 'Protection' tab

7. Change the password to one of your choice. Be careful not to remove the protection at this stage, but only to set a known password.

8. Save and close the Excel file.

9. You can now reopen it and disable the protection using the password you entered earlier.
0
Max
 
Incredible! Thanks for the tip. It's still embarrassing to lose your own passwords. With that, I was able to recover 2 days of work :-)
1