Page 25 of 32PREVNEXT

Help secure and protect data in Excel

Macros with a seal of approval are accepted by a computer but virus infected macros are rejected

Macro detection and digital certificates enable you to download macros from trusted sources.

There are two security features in Excel that are essential in helping protect you against macro viruses:

  • Macro detection using macro security levels
  • The Trust all installed add-ins and templates feature

These two features interact with each other, and you need to set up both to reduce your computer's vulnerability.

Before looking at these features in greater depth, you need to know more about deciding whom to trust. You can do this by looking at the macro creator's "credentials" on a digital certificate.

Page 25 of 32PREVNEXT