Enable or disable macros

Which Office program are you using?

Word

PowerPoint

Excel

Word

To help prevent macros that contain viruses from contaminating your system, by default Office for Mac displays a warning message whenever you try to open a document that contains a macro. This message appears regardless of whether the macro actually contains a virus. You can turn off the warning message, but if you do, make sure that you know and trust the source of the document before you open it.

  1. On the Word menu, click Preferences.

  2. Under Personal Settings, click Security  Security Preferences button .

  3. Do one of the following:

To

Do this

Enable macros when you open a file

Clear the Warn before opening a file that contains macros check box.

Note: If you disable macro virus protection, you run the risk of infection, which could result in serious damage to your data.

See the warning message when you open a file that has a macro

Make sure that the Warn before opening a file that contains macros check box is selected.

See also

Create, run, edit, or delete a macro

PowerPoint

To help prevent macros that contain viruses from contaminating your system, by default Office for Mac displays a warning message whenever you try to open a document that contains a macro. This message appears regardless of whether the macro actually contains a virus. You can turn off the warning message, but if you do, make sure that you know and trust the source of the document before you open it.

  1. On the PowerPoint menu, click Preferences.

  2. On the toolbar, click General  PowerPoint General Preferences button .

  3. Do one of the following:

To

Do this

Enable macros when you open a file

Clear the Enable macro virus protection check box.

Note: If you disable macro virus protection, you run the risk of infection, which could result in serious damage to your data.

See the warning message when you open a file that has a macro

Make sure that the Enable macro virus protection check box is selected.

See also

Create, run, edit, or delete a macro

Excel

To help prevent macros that contain viruses from contaminating your system, by default Office for Mac displays a warning message whenever you try to open a document that contains a macro. This message appears regardless of whether the macro actually contains a virus. You can turn off the warning message, but if you do, make sure that you know and trust the source of the document before you open it.

  1. On the Excel menu, click Preferences.

  2. Under Sharing and Privacy, click Security  Security Preferences button .

  3. Do one of the following:

To

Do this

Enable macros when you open a file

Clear the Warn before opening a file that contains macros check box.

Note: If you disable macro virus protection, you run the risk of infection, which could result in serious damage to your data.

See the warning message when you open a file that has a macro

Make sure that the Warn before opening a file that contains macros check box is selected.

See also

Create, run, edit, or delete a macro

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×