To use all of the great features of our software, macros must be enabled when prompted by Excel. Macros are used by Excel and makes our software a powerful analysis tool… such as drop down menus, print screens, solve backwards for the optimal purchase price, insertion of pictures and logos, etc.
The security feature in Excel (and all Office documents) requires you to first enable macros when opening our software. This security feature is designed to prevent macros from running automatically for security purposes. To make this feature automatic, you need to “accept” our digital certificate by selecting “Trust all documents from this publisher.” The digital certificate authenticates that we are the author and developer of the software. In other words, you can trust us!
Macro settings are located in the Trust Center. However, if you work in an organization, the system administrator might have changed the default settings to prevent anyone from changing settings.
- Click the File tab.
- Click Options.
- Click Trust Center, and then click Trust Center Settings.
- In the Trust Center, click Macro Settings.
- Select “Disable all macros with notification“
- Click OK. Close Excel, do NOT save the file, and Reopen Excel by double clicking on our desktop icon. Excel must be closed and reopened before the setting will take effect.
The following image is the Macro Settings area of the Trust Center.
Macros automate frequently-used tasks; many are created with VBA and are written by software developers. However, some macros pose a potential security risk. A person with malicious intent can introduce a destructive macro, in a document or file, which can spread a virus on your computer.
In the “Macro Settings” window, there are four options that you could choose. And here we will explain the difference among those options. Thus, you can know about the enable/disable macros in your worksheet.
- Disable all macros without notification
Suppose you will never use any macros and want to disable them, you may choose this option. The next time you open a macro-enabled Excel workbook, you will not see any notifications about macros.
However, you can still open the Visual Basic editor and check the codes. But the macros in the file are all in design mode.
When you press the button “F5” on the keyboard or click the button “Run Sub” in the toolbar, you will see this information like the image shows.
The macros in this file are all disabled and you are unable to run any of them. This is the effect of the first option in macro settings.
- Disable all macros with notification
By default, Excel will choose this option for macro settings. And the difference between the two options is the notification. Under this option, when opening a macro-enabled workbook, you will see the security warning. And there is also a button “Enable Content”.
If you directly open the Visual Basic editor and run a macro, you will again see the information shows that macros are disabled. But now you are sure that this macro is safe, you can reopen the file. Then click the button “Enable Content” in the “Security Warning”. Thus, the macros in this macro-enabled file are all available. What’s more, the nest time you open this file, you will not see this warning. Excel is smart enough to note down your manipulation and it remembers that this file is safe.
- Disable all macros except digital signed macros
Here comes the third option. This option is very easy to understand. When you choose this option, all the macros will be disabled. But there exist certain macros and they are digitally signed. And those macros are treated as safe. Therefore, under this option, you can run these signed macros in your computer.
When you choose this option, you can run all the macros in macro-enabled files. In addition, there is also an explanation next to this option show that it is not recommend to check this option. This is true because sometimes it’s hard for you to distinguish the malicious macros. And the result of those malicious files can be disastrous. Unless you can make sure that you will not receive those unusual files, you are not recommended to choose this option.
The above are the deep analysis about those macro settings. Hence, you could choose them according to your need.
There exists a different condition when you choose the first option for the macro setting. You will find that you can still run macros in certain macro-enabled workbooks.
This is because Excel can remember your previous operation. Before you choose the first option for the macro setting, the default setting is “Disable all macros with notification”. Under this condition, you have clicked the button “Enable Content” for those macro-enabled workbooks. And Excel remembers this operation. Actually, the memory of process is that Excel will add the file to the trusted documents when you click “Enable Content”. Hence, you will not see the security warning the next time you open the file. And even if you change the macro setting into “Disable all macros without notification”, those files are trusted documents. Therefore, you can still run macros in those files. If you need to disable them, you may follow the steps below.
- In “Trust Center” window, choose the option “Trusted Documents”.
- After that, click the button “Clear” in the window.
- Next you will see a pop-up window. Click “Yes” in this dialog.
- After that, click the button “OK”. Thus, all the trusted files are cleared. And now, you cannot run any macros in those macro-enabled files.