Mastering VBA for Microsoft® Office 2010

Chapter 19. Securing Your Code with 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 parts: 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

• Designate trusted publishers

• Lock your code

Understanding How VBA Implements Security

Macros, dialog boxes, and user forms that you write are computer ...