original link: http://yhf8377.blog.163.com/blog/static/1768601772012102111032840/before this, the first emphasis, this method is only used to crack the Excel internal VBA project, want to crack Excel file open password of the classmate can drift over ...First, if the file format is Excel version 2010 (. XSLM), you need to first open the Excel file and save it as the 2003 format (. xls). then use the normal text editor (I use notepad++) to open this file, note the file type select "All Files". then find "DPB" in the file and change it to "DPx". Note case. Save the changes. Then use Excel to reopen the file. You will encounter some errors and ignore them. then go to Excel's Development tools panel and select Visual Basic. There will be a series of errors, ignoring them, knowing that the VBA project is open. You can now view the VBA code. If you want to change or even remove the original password, continue to look. from the VBA Editor Tools menu, select VBA Project Properties ..., and then go to the protection panel. Enter the new password in the Password box. (even if you want to remove the old password, you must first set a new password, and then follow the next steps to remove the password.) )Save the VBA file and the Excel file, and close Excel. Restart Excel and reopen the file, and then enter Visual Basic, developer tools, prompting for a password. Enter the password for your new settings. then go back to the VBA editor tools, VBA project properties, protection, remove the password and the tags that precede the protection option. All right, save the file, it's done! (Every time I say this, I always think of Wei Xiaobao and Shuang-er ...) )
[reprint] How to hack Excel VBA password
