Switch on or switch off macros in Microsoft 365 files (2024)

A macro is a number of assignments that are used to automate a repeated task and can be performed when you have to perform the task.However, some macros can form a security risk by introducing viruses or malignant software on your computer.

Warning:Never activate macros in a Microsoft 365 -File, unless you know for sure that you know what these macros are doing and you want the functionality they deliver.You do not have to enable macros to edit the file.See for more info, seeProtect yourself against macro viruses.

Make a document that trusts to engage macros

If you see a security warning when you open a document or try to perform a macro, you can choose to make it a trusted document and a macros.This example is on an Excel workbook.

1. to electTurn on content.

2. ISafety WarningDialog, selectInTo familiarize the document.

   

Macros are now enabled in this document.To withdraw a trusted document, you must delete all the trusted documents.For more information, seeReliable documents.

Tip:Instead of activating macros for each document, you can make a trusted place to save trusted documents. Microsoft 365 will then note them with the Trust Center. See for more information, seeAdd a trusted location, delete or change on Microsoft Office.

Change the Macro settings in Trust Center

Macro settings are located in the Trust Center.But if your device is managed by your work or school system administrator, there may be someone to change settings.

Important:When you change your macro settings in the trust center, they only point to the Microsoft 365 app that you are currently using.The macro settings do not change for all your Microsoft 365 apps.

1. to electFilThe tab and selectPossibilities.

2. to electTrust centerand then selectTrust Center -Settings.

3. ITrust center, To electMacro settings.

   

   Tip:If you haveThe tab is developingYou must choose on your tapeDeveloperTab then Select Macro securityto openTrust centerfast.

4. Make the choices you want and then selectMagn.

   See Also

   Excel -Macros - Understanding codesHow is a hidden macro detached?Quick start: create a macroTo activate macros in Excel |

The following are macro settings settings.Not all apps have the same choices.

Remark:The options are slightly different in Excel, we call them out while we go.

• Switch off all macros without a reviewMacros and security warnings for macros are disabled.

  This option is in ExcelSwitch VBA -Macros off without assessmentAnd this only applies to VBA macros.

• Switch off all macros with assessmentMacros are eliminated, but security warnings appear when macros are present.

  

  Use this option to switch on macros in a case - -case basis.

  In the Exceleis institutionSwitch VBA -Macros off with assessmentAnd this only applies to VBA macros.

• Switch off all macros, except digitally signed macrosMacros are eliminated and security warnings appear when there are no -signing macros.But if the macro is digitally signed by a trusted publisher, the macro just runs.If the macro is signed by a publisher, you have no confidence in the possibility.To activate the signed macro and trust the publisher.

  In the Exceleis institutionSwitch VBA -Macros off except digitally signed macrosAnd this only applies to VBA macros.

• Enable all macros (not recommended, possibly dangerous code can be performed)All macros are executed without confirmation.This setting makes your computer vulnerable to malignant code.

  In the Exceleis institutionVBA -Macros switch on (not recommended, possibly dangerous code)And this only applies to VBA macros.

• Excelalalo has a check box forSwitch on Excel 4.0 macros when VBA -Macros are switched on.If you choose this check box, all the above settings for VBA -Macros also apply to Excel 4.0 (XLM) macro's. If this check box is not selected, XLM Macro is switched off without assessment.

• Trust access to the VBA project object modelBlock or give programmatic access toVisual Basic for Applications (VBA)Object model of an automation client.This security option is written for code to automate a Microsoft 365 program and to manipulate the VBA environment and the object model.It is an institution per. users and per application and refuses standard access and prevents not -authorized programs building harmful self -replicating code.Customers can have access to automation.

  Remark:Microsoft Access HasnoAccess to trust to VBA project model - Objectpossibility.

Also see

Change Macro security institutions in Excel

Quick start: Make a macro in Excel.

Block suspicious macros at the office at Windows 10 S.

How malware can infect your PC