Features on the BU WebGo to BU Home Page
spacer
spacer

Protecting Against Macro Viruses

What is a macro virus?

A macro virus is a computer virus that is written in the macro language of a program such as Word or Excel or Access. It is attached to a document or template file and spreads when that file is opened

Macro viruses do not travel freely over the Internet or any other media; they only spread when you open an infected document or template. For example, if you open a Word document or template that has a macro virus, then any other Word document that you open on your computer can also get "infected" by the macro virus.

Some macro viruses are just annoying, but others are very destructive. These viruses can spread very rapidly. Fortunately, once you know about macro viruses, it is easy to protect yourself against them – read on for details.

How can I tell if I have a computer virus?

(Information in this section is from the Microsoft Web site)

It is not always easy to determine whether you have a macro virus.

If you are familiar with the Word macros you have on your system, you can go to Tools® Macros and look through the various macros for ones that you do not recognize. It is possible that one, or more, of them are part of a macro virus that has infected your system. Some examples of these type of macro names are: AAAZAO, AAAZFS, AutoOpen, FileSaveAs, and PayLoad.

Some other things to look for are:

  • Unexplainable behavior on your system; for example, you may be prompted for a password on a file that you know does not contain a password or your document may be unexpectedly saved as a template.
  • Unusual error messages, for example: ROBERTA TI AMO!

Will old versions of Word or Excel (prior to Word97 and Excel 97) protect me from macro viruses?

These older versions of software have no built-in protection from macro viruses, but you can protect yourself by running a current anti-virus program and by being aware of symptoms of macro viruses. If you receive a suspicious document, you can disable all macros by holding down the Shift key each time you open the document. For more tips on macro virus protection in older versions of Word and Excel, see http://support.microsoft.com/default.aspx?scid=fh;EN-US;KBINFO

You might consider upgrading to a newer version of Word or Excel that does have macro virus protection – that’s what Microsoft suggests, but they do have a vested interest! On the other hand, some macro viruses are written specifically to infect newer versions of software and may have no effect on the older ones. It’s a trade-off – probably macro virus protection alone is no reason to decide to upgrade, but if you have other reasons for upgrading, go ahead.

Will Office 97/Office 98/Office 2000 protect me from macro viruses?

 

Yes – if you let it. Microsoft Office applications including Microsoft Word and Microsoft Excel are designed to protect you from macro viruses, provided the macro virus protection in these applications is turned on (which is the default setting). With the macro virus protection turned on, every time you open a document that contains macros, a dialog box appears and asks you to choose whether to enable or disable included macros.

  • You should always disable macros when you are not certain of their purpose or functionality. By choosing to disable the macros, you will prevent any macro viruses from running, preventing infection by the virus.
  • A macro virus is only activated if you open the attached document and choose to enable the macros or if your macro virus protection settings have been previously turned off and you open the attachment.

How do I ensure the Office 97/98/2000 macro virus protection is turned on?

(Note: This information comes directly from Microsoft)

IMPORTANT: If you are not able to follow the steps below because you cannot find the menu items, you may already be infected. If so, run anti-virus software containing the latest update, and scan your system often. If you are not able to run anti-virus software, it will be necessary to delete or rename your normal.dot file on a PC or your Normal file on a Mac. This is Word's global template that will automatically be recreated once Word is launched. After this is done, repeat the steps below.

In Word 97/98 and Excel 97/98

1.On the Tools menu, click Options (on a PC) or Preferences (on a Macintosh).

2.On the General tab, check Macro Virus Protection.

 

Enabling virus protection in Word 97

 

Enabling virus protection in Excel 97

In Word 2000 and Excel 2000

  1. Double-click on the Tools menu, point to Macro and then choose Security.
  2. Select the level of security you want.
  • High security will allow only macros that have been signed to open. Unsigned macros will be automatically disabled.
  • Medium security always brings up the macro dialog protection box that allows you to disable macros if you are unsure of the macros.

How do I ensure I will not be infected? What should I do if I think I have been infected by a macro virus?

  • Ensure the Office macro virus protection is turned on as described above. Always choose "disable macros" when asked, if you are unsure of the purpose of the macro in the document. Doing so will still allow you to open the document and read its contents. Once certain the macro is safe, and only if you need to run the macro, you can then re-open the document and enable the macro.
  • Run the latest anti-virus software, and scan often. This is how you can ensure that the macros in documents are safe. Also remember to keep your anti-virus software up to date by installing the latest signature files for that company. (Most companies creating anti-virus applications release a new signature file each month.) Boston University has a site license for McAfee VirusScan and Virex anti-virus software, which is available to you at BU's anti-virus software Web site.
  • Communicate this information to all those who could become infected.

Resources

 

 

Written by Clare Shawcross for the
Personal Computing Support Center

Return to main virus information page

22 February 2000
Office of Information Technology
Boston University
Questions