VBProject Tools-->VBA Project Propeties password protected

Is there any way i can change the project property? When i go to VB screen in an excel sheet , i see that the Tools-->VBA Project Properties is password protected.

Answers


I've had some success with this method in the past, i.e. I have managed to unlock some VBA projects with it, but with other files it has failed for some unknown reason.

  • Close the workbook and open the workbook file in a 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.

As ever, make a backup before you attempt to change anything as you may be left with a corrupt file if this fails.


Need Your Help

Creating a website in html not xml

html

Call me crazy but I have been trying to make an HTML website using Visual Studio 2012 but every time I open the program and create a webpage it automatically makes it an XML. Is this normal? Is thi...

Dynamic UILabel content inside of a UIScrollView

iphone cocoa-touch uiscrollview uilabel

I've got a UILabel (amongst other controls) stored within a UIScrollView. I want to dynamically populate the UILabel so that it automatically expands its height to fit its contents. I'm just wonder...