Change/Remove the Password of a Password-Protected VBA Project in Microsoft Excel

By -
Some Excel VBA developers are protecting their codes and modules with password in order not to let others view the content of their project. It's okay to open these files if you really knew the purpose of the project. But, what if you're in a company having bundles of confidential information that you're not allowed to divulge to any other parties and the Macro runs Malicious Codes to obtain such information. Or in worst cases, can also be used to spread viruses over the network you're connected with.

One day, you might have received an email from a friend with an excel file attachment containing macros in it. And you are told to open it because He/She has a data that needs to show to you. And when you open it, suddenly you're system got compromised.

So if you have the basic understanding with the programming language (VBA), then you might want to know what are the codes and applications are running when you open the excel file. But that doesn't end there!

When you try to open and view the VBA Project it prompts you to input a password in which you don't have an idea unless if He/She gave it to you. And if you're good at guessing then guess the PASSWORD!

We'll, I guess that's not a good idea. But the good news, is that you can set the VBA Project's Password to a password of your own.
Changing/Removing the Password:

So what do you need?
1.) You need to create a new Excel File with a known VBA Project Password.
     a. Open Microsoft Excel, Press Alt+F11 to open the Microsoft Visual Basic window.
     b. Set the VBA Project Password to '1234'. See How to Set Password on Excel VBA Project.
     c. Save the file as "password.xls" on your desktop or to location you can easily access.
     d. Close the file.

2.) You will need any HEX Editor. You can download a free and portable HEX Editor here.
     a. After Downloading, extract the compressed package and open theHxD.exe on the output folder.
     b. Browse the Excel File that you want to change/remove the password and the Excel file you've just created with a known password.
     c. Drag and Drop the files on the HEX Editor's Window. As you can see below.
HEX Editor

     d. Now on the HEX Editor's Window, Select the password.xls tab.
     e. Press Ctrl+F, type "cmg" without the "" then press enter. CMG will now be highlighted.
     f. Now, Select CMG and DPB values as you can see below and Press Ctrl+C to copy.
   
     g. Next, select the PasswordProtectedVBAProject.xls tab and repeat steps e & f.
     h. Now that you've selected the CMG and DPB values of the Password Protect VBA Project. Press Ctrl+V to paste the ANSI data from the password.xls file.
     i. Save the PasswordProtectedVBAProject.xls and close the HEX Editor Window.

You can finally open the VBA Project!

When you open the Password-Protected VBA Project, you'll now be able to open and view the modules and codes using the password '1234'.

And then you found out that the macro is only saying "HELLO WORLD!" =:)

Comments

  1. SEO Tips 2021June 10, 2021 at 2:48 PM

    How To Password Protect a Folder on Windows 10/8 - No Additional Software Required

    In this video, we will see how to Create Password Locked Folder In Windows 10/8. So we will see How to Lock Folders in Windows 10 without Software.

    People always ask this question How do I password protect my files and folders in Windows? Today's video will finish all their questions and they will learn them completely.

    Apurbo IT Services tips or secrets series may help you.

    ReplyDelete
  2. AnonymousApril 18, 2022 at 12:10 AM

    Change/Remove The Password Of A Password-Protected Vba Project In Microsoft Excel >>>>> Download Now

    >>>>> Download Full

    Change/Remove The Password Of A Password-Protected Vba Project In Microsoft Excel >>>>> Download LINK

    >>>>> Download Now

    Change/Remove The Password Of A Password-Protected Vba Project In Microsoft Excel >>>>> Download Full

    >>>>> Download LINK OM

    ReplyDelete

Post a Comment

Popular posts from this blog

How to Create a Configuration.INI Files in VB6

By -
Image
In this example shows only a simple form that saves and retrieves value from the CONFIG.INI file. After reading this, you can use your own creativity on how you're going to implement this on your project. To start with, On your Form add the following controls and arrange them according to the image above. (1) TextBox - Change the Name property to "txtSetting" (2) Command Button - Change the Caption and Name Properties to the following:                                        Save:          Change the Name property to "cmdSave"                                        Retrieve:    Change the Name property to "cmdRetrieve" (5) Label - For the two labels we'll be using to retrieve the values. Remove the default caption and change the Name Properties to lblName and lblTime . Now, Copy the Form Codes below and Paste on the Form1 code window of your VB6 Project. Form Codes: Option Explicit Dim ConfigFile As String Private Sub cm
Read More »

How to Make Windows Form Transparent using Visual Basic 6/VB6

By -
The following code snippets allows you to make windows form transparent using VB6. In a standard module, copy and paste the following declarations and function. [ Module1.bas ] Option Explicit Const LWA_COLORKEY = 1 Const LWA_ALPHA = 2 Const LWA_BOTH = 3 Const WS_EX_LAYERED = &H80000 Const GWL_EXSTYLE = -20 Private Declare Function SetLayeredWindowAttributes Lib "user32" (ByVal hWnd As Long, ByVal color As Long, ByVal x As Byte, ByVal alpha As Long) As Boolean Private Declare Function SetWindowLong Lib "user32" Alias "SetWindowLongA" (ByVal hWnd As Long, ByVal nIndex As Long, ByVal dwNewLong As Long) As Long Private Declare Function GetWindowLong Lib "user32" Alias "GetWindowLongA" (ByVal hWnd As Long, ByVal nIndex As Long) As Long Private Declare Function WindowFromPoint Lib "user32" (ByVal xPoint As Long, ByVal yPoint As Long) As Long Private Declare Function GetCursorPos Lib "user32" (lpPoint As POINTAP
Read More »

How to Set Windows Form Always on Top of Other Applications in VB6

By -
The following code snippets allows to set Windows Form Always on Top of Other applications in Visual Basic 6.0. Public Const SWP_NOMOVE = 2 Public Const SWP_NOSIZE = 1 Public Const FLAGS = SWP_NOMOVE Or SWP_NOSIZE Public Const HWND_TOPMOST = -1 Public Const HWND_NOTOPMOST = -2 Declare Function SetWindowPos Lib "user32" _ (ByVal hWnd As Long, _ ByVal hWndInsertAfter As Long, _ ByVal x As Long, _ ByVal y As Long, _ ByVal cx As Long, _ ByVal cy As Long, _ ByVal wFlags As Long) As Long The following SetTopMostWindow() function takes two parameters as follows:       hWnd : the window handle       Topmost : It is either True to set the on top or False if Not. Public Function SetTopMostWindow(hWnd As Long, Topmost As Boolean) As Long If Topmost = True Then 'Make the window topmost SetTopMostWindow = SetWindowPos(hWnd, HWND_TOPMOST, 0, 0, 0, 0, FLAGS) Else SetTopMostWindow = SetWindowPos(hWnd, HWND_NOTOPM
Read More »