By default, Microsoft Excel offersVBA password protectionas a way to protect VBA code. This method of VBA code protection is weak and can beeasily cracked. TheDoneEx XCell Compilerprovides amuch better and much stronger solution to protect your VBA codefrom being stolen. You can apply strong ...
Like we protect our worksheets in Excel; similarly, we can use VBA to protect our worksheets. There are two methods to protect the sheet using a .protect statement. One is with a password, and another is without a password. The syntax to protect a worksheet is as follows Worksheets().Pr...
I wanted to make an Excel Add-In module so I've created an .xlam file. Now, I want to password-protect the code. What is the procedure? By "password-protect the code", I don't want my users to be able to read the code. Is this possible? Thanks in advance. All replies (26)...
Click on the add-in in the Project Explorer on the left-hand side. Select Tools > VBAProject Properties... (there may be a different name instead of VBAProject).
So, with a ‘VB-Decompiler’ the protection code efficiency of this approach is reduced to the level of the VBA code obfuscation approach. Low protection efficiency(X < W see above). VBA to VB.NET In contrast to VB6, the .NET languages can create 32-bit as well as 64-bit versions of...
I wrote a database in 2009/2010 in 2007. I migrated it to 2010, changed it to an accdb and password protected the VBA. In 2017, I left the company, handed over all of my passwords, and left my code in another's hands. In Sept 2021, they asked me to please come back, I did,...
strange issue. I lock a worksheet by Review>Protect Sheet and set a worksheet password such as 0010 and then in the VBA code I want to unprotect with the same password to run a piece of code. But it generates an error saying password doesn't match. Below is the code I use to ...
This is a small VBA code to help you in dealing withProtectingandUnProtectingthe WorkSheet using Excel Macro. Assuming the fact here that you knowHow to Protect or UnProtect a Sheet using Excel In-Built function. For those who do not know protect or unprotect the sheet using Excel inbuilt fu...
Paste VBA Code into your macro enabled Excel workbook using OfficeProtect, then wrap it into a single workbook application with AppProtect. The user needs 32 or 64-bit Windows Excel or Mac Excel 2016+. Microsoft Access Save your Access application as a 32 or 64-bit ACCDE file, then wrap...
No. The Access /decompile switch removes the compiled VBA code from an MDB file, ready for re-compiling. As soon as the VBA code is compiled again, the compiler junk exists again. Since all MDE and ACCDE files have to be compiled, the compiler junk is always present and makes it very...