There is another way to protect the VBA Project using passwords with the help of code.

Step 12: And if we enter the incorrect password we would then get an incorrect message alert. Step 11: This would enable the VBA Project with all the options and we will be able to see the code written in the module. To enter the password which we had chosen. Step 10: We will get the password window there. To test, click on the plus sign of the VBA Project. In the VBA window, we will see all the options like Modules in the VBA Project is hidden. Step 9: Now save the code and then close the VBA and Excel files. It is better to copy and paste the password to match and then Click on OK to exit. The password should be the same in Password and Confirm Password section as shown below. Step 8: We have chosen the password as “ Pa$$w0rd123” in the combination of Upper case, lower case, special character, and numbers. Preferably the password should be strong enough not be cracked easily by anyone. Step 7: Now in the Protection tab’s Password and Confirm password section write the password which you want. Step 6: We will then get the Project Properties as shown below. Now to protect the VBA Project with a password, go to Tools menu option and select VBA Project properties as shown below. We would notice that the code has run without any error. Step 5: To test this, we would run this code by pressing F5 or Play Button is mentioned below the menu bar.

This is the simplest code that we protect using the VBA Project password. Step 4: And last to close the code, use Debug print to print the value whichever could be stored in variable A. Step 3: Use DIM to define a variable as an Integer.

Ms access password protect vba code