VBA articles

Performance and Optimization

VBA Speed Up

VBA Benchmarks

Optimize VBA Code

 

Security

Why the Standard Excel VBA Password Protection is Broken (and How to Fix It)

VBA Obfuscation vs. Compilation

Best Way to Protect VBA code

Remove VBA Password

How to Protect Excel Add-In from Being Pirated or Shared

 

Compatibility

32-Bit / 64-Bit Architecture Conflicts and Compatibility in Excel VBA

Fix the Excel “Microsoft Has Blocked Macros From Running” Error