Mastering VBA for Microsoft Office 2016

Chapter 19Exploring VBA's Security Features

This chapter discusses how to use the security tools that VBA provides for distributing and implementing macros and VBA code. VBA security falls into three categories: securing your applications against rogue VBA code; establishing that your VBA code isn't itself rogue so that it can be run; and securing your code against theft, alteration, or snooping.

In this chapter, you will learn to do the following:

• Understand how VBA implements security
• Sign a macro project with a digital signature
• Get a digital certificate
• Choose the appropriate security level
• Lock your code

Understanding How VBA Implements Security

Macros are computer programs, albeit usually rather small ones. But because macros ...