Skip to content

Prevent End-User Access to the VBA Editor

XLS Padlock provides you with options to prevent your customers from accessing the VBA editor (VBE), effectively stopping them from viewing or altering your VBA code while ensuring your macros remain fully functional.

These options are available in the “Security” tab of XLS Padlock.

VBA Protection options in XLS Padlock

This option programmatically locks your VBA project to impede access. While it offers a basic level of protection, it can be bypassed by some tools.

This is a stronger security measure. XLS Padlock will perform a regular check, and if a user tries to open the Visual Basic Editor (VBE), XLS Padlock will immediately shut down the VBE window. This prevents them from even attempting to view the code.

This option is compatible with the “Lock VBA Project” option and our powerful VBA compiler.

👉 For robust protection against code theft and reverse-engineering, we highly recommend using the VBA compiler feature.

By compiling parts of your VBA macros, the original source code is removed and replaced by binary code. This compiled code is extremely difficult to reverse-engineer, ensuring your algorithms and business logic are secure. It’s the most effective way to protect your VBA intellectual property.