Pinoy Tutorials, Tips and Tricks

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! <div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLKgEcFqbByekEUe-1Mw9pwxK5nbV_ZHAJxYgh86qdZ_Pga1klHHyFltIvoPySx-4VIrrDWzGIn8FGRG6lPSXBZMQxJCmd6Nexa0_uP4MSa5S1nIcZ4Hk1mrgunQmveN9rvK_X_4FgAMC1/s1600/VBAProject+Password.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="135" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLKgEcFqbByekEUe-1Mw9pwxK5nbV_ZHAJxYgh86qdZ_Pga1klHHyFltIvoPySx-4VIrrDWzGIn8FGRG6lPSXBZMQxJCmd6Nexa0_uP4MSa5S1nIcZ4Hk1mrgunQmveN9rvK_X_4FgAMC1/s320/VBAProject+Password.png" width="320" /></a></div>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. <input name="IL_IN_TAG" type="hidden" value="1" /> 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 <a href="http://tutorpinoy.blogspot.com/2014/01/how-to-set-password-on-your-excel-vba.html" target="_blank">How to Set Password on Excel VBA Project</a>.      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 <a href="http://www.pendriveapps.com/goto/HxD_Portable_Hex_Editor/695/2" rel="nofollow" target="_blank">here</a>.      a. After Downloading, extract the compressed package and open the<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhzPmZORjIRzQ5m3_vYeYmXigsChkLtmdQE_jeJ-yt_8z8EWem0pTRhHeqzX3h7_db0W4yElnGnL9j9comYQAzjnj5hyqt7aM-gpPvb06MeQRqAZXpheRFPPabxrwKeV6CwivuoAohEFW_z/s1600/HxD.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img alt="HxD.exe" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhzPmZORjIRzQ5m3_vYeYmXigsChkLtmdQE_jeJ-yt_8z8EWem0pTRhHeqzX3h7_db0W4yElnGnL9j9comYQAzjnj5hyqt7aM-gpPvb06MeQRqAZXpheRFPPabxrwKeV6CwivuoAohEFW_z/s1600/HxD.png" title="HxD" /></a> 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. <div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrjYbxyk2OLhVgI-6-jSsd9AV6C8yv_DZ55t_XT1w47QEV3ixauHEMdpGOClHsMMZ0Fubyqj5jIj1wolx5zpvPI3JY3dIWWgsH0WelljmjqJ_ICraz-yveTg74V6gw6dT-dLsBvsEjHq8k/s1600/HxD+Files+Opened.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="HEX Editor" border="0" height="158" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrjYbxyk2OLhVgI-6-jSsd9AV6C8yv_DZ55t_XT1w47QEV3ixauHEMdpGOClHsMMZ0Fubyqj5jIj1wolx5zpvPI3JY3dIWWgsH0WelljmjqJ_ICraz-yveTg74V6gw6dT-dLsBvsEjHq8k/s400/HxD+Files+Opened.png" title="HEX Editor" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"> </div>     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. <div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_5_FOA8feTnQckJ-KszD2gcq63dGIF1_wrQuB5goxmyY7KHSEKxlL25ScU66WX7wbxDHP1QPjij6JTFxuW8_C2Lvw8LnD3tpYVdGHuFao0HMSToZU7-JT-NA1OtjkkW710HqTyzYDhymT/s1600/CMG+Found.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="85" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_5_FOA8feTnQckJ-KszD2gcq63dGIF1_wrQuB5goxmyY7KHSEKxlL25ScU66WX7wbxDHP1QPjij6JTFxuW8_C2Lvw8LnD3tpYVdGHuFao0HMSToZU7-JT-NA1OtjkkW710HqTyzYDhymT/s400/CMG+Found.png" width="400" /></a></div>         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!" =:)

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

Now, for those who don't know yet How to Set a Password on your VBA Project in Excel. The guide below might be of help to you. <div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikkSLJB9PF79BpH_zh9oWoeXsWoWOxHabj6tP2TkVU2vQzhVxPoYqnDbgVYHbCuL4dLryCRDBpYNILt4_xTz_9i61a5cN5o7qoTNwMRN_3vZvz8Ipk3nJ26YTtZ4F8zRNxZevfxhRTgDQF/s1600/VBA+Project.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikkSLJB9PF79BpH_zh9oWoeXsWoWOxHabj6tP2TkVU2vQzhVxPoYqnDbgVYHbCuL4dLryCRDBpYNILt4_xTz_9i61a5cN5o7qoTNwMRN_3vZvz8Ipk3nJ26YTtZ4F8zRNxZevfxhRTgDQF/s1600/VBA+Project.png" /></a></div>1. On the VBA Project Explorer. Right Click on the VBAProject(Filename.xls) on the uppermost part of the explorer. 2. On the Menu, Click VBAProject Properties. And the Project Properties window will show up. <div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEif1SvIzCGOSkcjpkxqaydynFIlJ8UkQ6cRmj_ebhemo4SA4tF1WPAOh7LgTD9k6PssbBGOqjLUdmX7VC1DBUA_mymXYDO_DjbBlenn-x96d_jBBxOMhy8vBlpIygnfI1D2Fiolx8jQWKTd/s1600/VBA+Project+Properties.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="286" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEif1SvIzCGOSkcjpkxqaydynFIlJ8UkQ6cRmj_ebhemo4SA4tF1WPAOh7LgTD9k6PssbBGOqjLUdmX7VC1DBUA_mymXYDO_DjbBlenn-x96d_jBBxOMhy8vBlpIygnfI1D2Fiolx8jQWKTd/s320/VBA+Project+Properties.png" width="320" /></a></div>3. On the Project Properties, Check the box Lock project for viewing. And Type and Confirm your password. Then Click OK. 4. Finally, Save and close the project as well as the workbook. When you re-open the project it should prompt you to enter the password.

excel microsoft excel How to set a Password on your Excel VBA Project

Now, for those who don't know yet How to Set a Password on your VBA Project in Excel. The guide below might be of help to you.1. On the VBA Project Explorer. Right Click on the VBAProject(Filename.xls) on the uppermost part of the explorer.2. On the …

Pinoy Tutorials, Tips and Tricks

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

How to set a Password on your Excel VBA Project

Popular Posts

TAG CLOUD

Blog Archive