VBA Tips: Various
Various tips
- Disable events
- Enable (and unblock) Excel macros
- Perform an action depending on Excel’s version
- Simplify conditions in VBA
- Stop a running macro
- Ternary operator
- Using ScreenUpdating to speed up the execution of a macro
- VBA code protection (obfuscator)