I found these steps in one of my mails. I was trying hard to remove the password for TD upload add-in when I encountered this and I kept a copy on mail (I was not blogging at that time :)) I was not aware of the OTA at that time so was very curious to look how that add-in was written. Hope this is useful in case you don’t remember the password for any of your add-in.
- Get a binary editor. You can easily get a freeware binary editor.
- Make a new Excel workbook, set a password in VBA Properties Dialog
- Save the workbook as an *.xls file
- Open the xls file with the Unknown password in the binary editor
- Open the xls file with the password we’ve created in step 2. Also with the binary editor
- Search using the binary editor’s in both the open files for “DPB”
- When you find this, there wil be a code attached to this and you will also find CMG code above and a GC code beneath
- Now all you do is to replace this section of code inr the xls file which you don’t know the password for with the password you know
- Save the file and run Excel and open the book with the password you’ve entered in step 2
- Always make a backup of the file with the UNKNOWN password, because editing with an binary editor can be fatal.