How to enable macros in Microsoft Office 2021 | enable macros in Microsoft Office

 

Open any Microsoft Office application such as Word, Excel, or PowerPoint.
Click on the "File" tab located in the upper left corner of the application window.
From the File menu, select "Options." This will open the Options window.
In the Options window, select "Trust Center" from the left-hand sidebar.
Click on the "Trust Center Settings" button on the right side of the window.
In the Trust Center window, select "Macro Settings" from the left-hand sidebar.
In the Macro Settings section, you will see several options. Choose the option that suits your needs. Here are the options and their implications:

• Disable all macros without notification: This option will prevent all macros from running, and you won't receive any prompts.
• Disable all macros with notification: This option will disable macros but show a notification each time a macro is trying to run. You can choose to enable the macros if they are from a trusted source.
• Disable all macros except digitally signed macros: This option allows only digitally signed macros to run. Macros without a digital signature will not run.
• Enable all macros (not recommended, potentially dangerous code can run): This option allows all macros to run without any restrictions. It is not recommended because it can expose your computer to potential security risks.

Once you have selected the desired option, click on the "OK" button to save the changes and close the Trust Center window.
Click on the "OK" button in the Options window to save your changes and close the window.
After following these steps, macros should be enabled in your Microsoft Office 2021 application. Remember to exercise caution when running macros, especially if they come from an untrusted source, as they can potentially harm your computer or compromise its security.

If you have enabled the "Enable all macros" option in the Trust Center settings of Microsoft Office 2021 and are still encountering the message "Microsoft has blocked macros from running because the source of the file is untrusted," it is possible that the file you are trying to open or the location from which it is being accessed is considered untrusted by Office.

To resolve this issue, you can try the following steps:

Open the file that contains the macros in the Office application (Word, Excel, PowerPoint) you are using.
When you see the message "Microsoft has blocked macros from running because the source of the file is untrusted," click on the "Enable Content" button. This will attempt to enable the macros despite the warning.
If the above step does not work, you can try moving the file to a trusted location. By default, the trusted locations include your Documents folder and subfolders. Move the file to one of these trusted locations and then try opening it again.
If the file is located on a network share or in a different location, you can add that location as a trusted location. To do this, follow these steps:

• Open any Office application and go to the "File" tab.
• Select "Options" and then choose "Trust Center" from the left-hand sidebar.
• Click on the "Trust Center Settings" button.
• In the Trust Center window, select "Trusted Locations" from the left-hand sidebar.
• Click on the "Add new location" button and browse to the folder or network share where the file is located.
• Once you have added the location, click on "OK" to save the changes and close the Trust Center window.

Try reopening the file. Office should now consider the location as trusted, and the macros should run without being blocked.

By following these steps, you should be able to enable and run macros in Microsoft Office 2021 without encountering the "Microsoft has blocked macros from running because the source of the file is untrusted" message.