![]() ![]() (This value generated for 'macro' password. Open the file you just extracted with a hex editor.įind and copy the value from parameter DPB (value in quotation mark), example:ĭPB="282A84CBA1CBA1345FCCB154E20721DE77F7D2378D0EAC90427A22021A46E9CE6F17188A".Find the file: 'vbaProject.bin' (in 'xl' folder).Change file extention to '.zip', open it by any archiver program.In the VBA part, set a simple password (for instance 'macro').Pasted from a previous post from his blog:įor Excel 2007/2010 (.xlsm) files do following steps: You can see how it works by browsing his code. ![]() Someone made a working vba code that changes the vba protection password to "macro", for all excel files, including. I have your answer, as I just had the same problem today: NEW: (TEST) GC="BAB816BBF4BCF4BCF40000" (what i used and what worked) NEW: (TEST) GC="BAB816BBF4BCF4BCF4" (from Ricko below) I used the "test" example given by Ricko at the bottom and it worked with ONE CAVEAT - i had to 'pad' out my GC value to make it that same length as the original one in my file. zip, editing the DPB= AND GC= values in the vbaproject.bin file with a hex editor then saving this in the. ![]() I DID manage to get this to work on an old windows machine (XP/Excel 2007) by modifying the. Something about changing the file from filname.xlsm to fielname.zip and back again results in a corrupted excel file which Excel 2011 refuses to recognise. I HAVE NOT been able to get this to work on Mac Excel 2011. ![]() Having now solved this (to some degree) i thought i'd add a summary here.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |