Microsoft Office Tutorials and References
In Depth Information
The VBA Editor.
Security and Macros
VBA is a powerful programming language. As such, it has the potential to do great harm to your
data and files. So-called macro viruses have become more common, and are typically spread when
Office documents are passed around as email attachments.
Outlook- based macro viruses are rarely if ever a problem because of the way its macros are stored.
With other Office programs, such as Word and Excel, macros can be a part of an individual
document and will go along with the document when it is forwarded as an attachment, thus permitting
a malicious macro to be spread. In contrast, Outlook macros are not part of any document but are
associated and stored with the Outlook program itself. In other words, you cannot pass an Outlook
macro to someone else by sending them an email or any other Outlook data (you can specifically
export an Outlook macro to send to someone else, but in that case it’s obvious what’s happening).
Does this mean that you need not be concerned with macro security? Absolutely not! Chapter 20
explains a variety of measures that Outlook users should take with regards to security.