Microsoft Excel - how I remove Password

Asked By Rajan on 20-Aug-11 01:19 AM

I want to know that how i remove or crack Excel VBA Password easily .

Thanks
Venkat K replied to Rajan on 20-Aug-11 01:29 AM
I used this approach today (on a 2003 XLS file, using Excel 2007) and was successful.
  1. Backup the xls file
  2. Using a HEX editor, locate the DPB=... part
  3. Change the DPB=... string to DPx=...
  4. Open the xls file in Excel
  5. Open the VBA editor (ALT+F11)
  6. the magic:Excel discovers an invalid key (DPx) and asks whether you want to continue loading the project (basically ignoring the protection)
  7. You will be able to overwrite the password, so change it to something you can remember
  8. Save the xls file
  9. Close and reopen the document and work your VBA magic!
Ravi S replied to Rajan on 20-Aug-11 01:33 AM
HI

Removing an Excel Workbook VBA Password

 

A VBA project password can be removed with a hex editor.

 Close the workbook and open the workbook file in the hex editor. 


Find the string "DPB" and change it to "DPx".

 Save the file.


 Open the workbook and click OK until the workbook is open 

(one or more dialogs are displayed describing various problems with the VBA project). 


Press ALT+F11, 

choose the menu command Tools->VBAProject Properties,


 navigate to the Protection tab,

 and change the password but do not remove it (note the new password). 


Save, close, and re-open the workbook.

 Press ALT+F11 and enter the new password.


 Choose Tools->VBAProject Properties,

 navigate to the Protection tab,


 and remove the password. 

Save the workbook.



Ravi S replied to Rajan on 20-Aug-11 01:35 AM
Hi

here are some softwares

refer the links 

Rajan replied to Ravi S on 20-Aug-11 01:50 AM

Dear Ravi

Thanks for reply.
Please tell me what is hex editor & how i use it

thanks
Ravi S replied to Rajan on 20-Aug-11 01:59 AM
Hi

A hex editor is a computer program used to view and edit binary files. A binary file is a file that contains data in machine-readable form (as apposed to a text file which can be read by a human - see Figure 1).

 Hex editors allow editing the raw data contents of a file, instead of other programs which attempt to interpret the data for you. Since a hex editor is used to edit binary files, they are sometimes called a binary editor or a binary file editor.

 If you edit a file with a hex editor, you are said to hex edit the file, and the process of using a hex editor is called hex editing.

Example

A VBA project password can be removed with a hex editor (I used the XVI32 Freeware editor fromhere).  Although I didn't discover this method, I'm happy to post the process with screenshots to help others.  Sometimes all we need is that little snippet of code in an old VBA project we've archived away...Open your chosen workbook file (.xls or .xla file) in the hex editor. It will look like the following;
Now search for the Text string "DPB" and change it to "DPx" (simply type over the value).
 Save the file over the top of the existing workbook and close. Now, open the workbook in Excel and click OK until the workbook is open (you may receive a couple of VBA errors on the way). Press ALT+F11 to open the Visual Basic Project window, From the Tools menu, choose the command VBAProject Properties, navigate to the Protection tab, and change the password but do not remove it (note the new password).
Save the workbook, close, and re-open. Once open, press ALT+F11 and enter the new password.Finally, choose Tools -> VBAProject Properties, navigate to the Protection tab, and remove the password. Save the workbook.
Riley K replied to Rajan on 20-Aug-11 02:20 AM
Try this:
Open the File using the password.
Then, click on the Microsoft Office button and click "Save As".
When the "Save As" dialog box appears, click on the "Tools" button which is
on the lower left of the dialog box.
Click "General Options".
Delete the password and click on "OK".
Finally, click on "Save" (make sure you have the desired drive and folder).
The file should now be saved without a password.
I hope this helps.
Good Luck.
Anoop S replied to Rajan on 20-Aug-11 03:17 AM
Removing an Excel Workbook VBA Password

A VBA project password can be removed with a hex editor. Close the workbook and open the workbook file in the hex editor. Find the string "DPB" and change it to "DPx". Save the file. Open the workbook and click OK until the workbook is open (one or more dialogs are displayed describing various problems with the VBA project). Press ALT+F11, choose the menu command Tools->VBAProject Properties, navigate to the Protection tab, and change the password but do not remove it (note the new password). Save, close, and re-open the workbook. Press ALT+F11 and enter the new password. Choose Tools->VBAProject Properties, navigate to the Protection tab, and remove the password. Save the workbook.

try this also, its free
http://www.brothersoft.com/remove-vba-password-165841.html
http://www.sobolsoft.com/excelremovevba/