HOW TO PROTECT VBA PROJECT EXCEL 20106 CRACKED
HOW TO PROTECT VBA PROJECT EXCEL 20106 CODE

Step 8: We would see the code has run successfully. If the password entered is correct then this window will be closed. Step 6: Now if we run the code by pressing F5 or the Play Button is mentioned below the menu bar, we would get the Password Protected window where we would enter the password. Step 5: And to see if the entered password is incorrect then we would get a message as Incorrect Password. Range('A1').Value = 'Workbook is secured.' Step 4: Open the Select Case-Else loop and there write the condition where if the entered password is вЂњPa$$w0rd123вЂќ then we would get the message as secured workbook in select range cell. PW = Application.InputBox('Enter Password', 'Password Protected') Step 3: In the defined variable PW we will use the Input Box application and choose the title and message which we would like to see. Step 2: Now write define a variable using DIM as a Variant.

Step 1: In the same module and write the subprocedure. 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.

HOW TO PROTECT VBA PROJECT EXCEL 20106 CRACKED

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.

How to protect vba project excel 20106