Questions

MS Excel's VBA Project!!!

Tags:
+
0 Votes
Locked

MS Excel's VBA Project!!!

kahsan
Hello!
My friend have given me an calendar excel file, in which he made a vba prjoect, the project was password protected, now he forget the password and now we both are looking for the solution, the file contains an automatic conversion of georgian year to islamic year, month and days with dates.
Kindly help its urgent!
Regards.
  • +
    0 Votes
    jobgkr

    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.

  • +
    0 Votes
    jobgkr

    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.