Note- When working in an organization, your system administrator might have modified the settings so that no one can change it. In this case, you have to take permission from the administrator.
Now, follow these steps to change macros settings in the Trust Center Settings.
- Click on “File,” then choose “Options.”
- Now, select the “Trust Center” option, then choose “Trust Center Settings.”
- Choose the “Macro Settings” option.
- Select one of the following options-
- Disable all macros without notifications: You won’t be able to run macros in that workbook.
- Disable all macros with notifications: You will receive a Security Warning, but you will be able to enable macros.
- Disable all macros except digitally signed macros: If the macros are created by VBA coders who have certificates from a commercial authority or a security administrator in your organization, then the macros will be enabled automatically. You won’t receive any Security Warning.
- Enable all macros (not recommended; potentially dangerous code can run): You will be able to run all the macros.
- Trust access to the VBA project object model: This option will allow other macros/ external analytics programs to modify macros.
- Choose the option which suits your requirements.
Method 5: Enable macros permanently for a specific workbook
You can enable macros for a particular workbook by modifying settings in the Trusted Documents option. Generally, trusted workbooks are present in a private list, and they are associated with your Windows login. Still, you can make some changes in the Trusted Documents by following these steps given below.
- Choose “File” and then click on “Options.”
- On the left side, choose “Trust Center” and on the right side, select “Trust Center Settings.”
- When the Trust Center dialog opens up, click on “Trusted Documents.”
- You can choose “Clear” to clear the list of trusted workbooks.
- If you want to disable the trusted documents, then check the box beside “Disable Trusted Documents” option.
Method 6: Add the workbook to a trusted location
If you move your workbook to your computer’s trusted location, then you can use macros on the workbook. The workbooks will open without any security warning. You can also add all your workbooks to the trusted location, follow these steps.
- Go to File > Options.
- In the left pane, select “Trust Center“, and then in the right pane, click on “Trust Center Settings.”
- Select “Trusted Locations“
- In the right pane, you can see all the trusted locations set by Excel.
- Select the “Add new location” option.
- You can see the Microsoft Office Trusted Location dialog box.
- Here, you can enter the path of the folder you want to use. You can also choose the “Browse” option to go to your preferred folder.
- If you want to add all the subfolders of that particular folder, you can check the box beside “Subfolders of this location are also trusted.“
- In the Description tab, you can write a description of the macros’ folder. It can come useful while you are managing several locations. You can also choose to skip the Description option.
- Click “OK,” and now you can enable macros in your Excel without any interruption.
Macros follow a set of sequences and can automate repeated tasks. Using macros can help you in saving time and energy. But if the macros are from hackers or hijackers and you enable them in your computer, you can lose valuable data and resources.
To save your files and data, Microsoft Excel chooses to disable macros. But if you know the macros’ creators, or you know the macros are from a trusted source, then there’s no worry. You can use our methods given above to enable macros in Excel. We hope this article was helpful. If you have any queries or feedback, please write down the comment in the below comment box.
