Pinoy Tutorials

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!

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 Menu , Click VBAProject Properties . And the Project Properties window will show up. 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.

This little trick will let you update Windows Service Pack from 1 to 3 without having to install any software and applications. This will only trick Windows to detect that Service Pack 3 is installed on your system. However, if you really want to install the Service Pack then you can download it on Microsoft's website. To do the trick, follow these steps below: 1.) Open Notepad Editor. 2.) Copy the Code below and Paste it on the Notepad Editor Window you've just opened. @echo off rem Create a Backup of the Registry Key we'll be updating. reg.exe export "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Windows" C:\SPBackup.reg /y rem Create the registry file (ServicePack.reg). echo Windows Registry Editor Version 5.00 >> C:\ServicePack.reg echo.>> C:\ServicePack.reg echo [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Windows] >> C:\ServicePack.reg echo "CSDVersion"=dword:0000300 >> C:\ServicePack.reg rem Save the