Microsoft explains what “digitally signed” means here:Įxcel uses digital signatures on the workbook contents to help ensure that the workbook has not been modified and saved since it was signed. All unsigned macros are automatically disabled without notification. If you have not trusted the publisher, you are notified. This only allows macros digitally signed by a publisher you’ve trusted to run. If you want to allow digitally signed macros to run, select the “Disable all macros except digitally signed macros” option. You can disable the Security Warning by selecting “Disable all macros without notification”. The “Disable all macros with notification” option is selected by default. The Trust Center dialog box displays with the Macro Settings screen active. In the “Code” section, click “Macro Security”. To do that, you’ll need to enable the Developer tab, then click on it.
#Disable macros in excel 2010 how to
We’ll also show you how to set up a trusted location for important files received from trusted sources.įirst, we’ll disable the Security Warning message bar. Office files placed in a trusted location are ignored when you open them from that location, and macros are not disabled. If you deal with some Office files that have macros from trusted sources, you can set up a trusted location in which you can place those trusted files for each Microsoft Office program. However, this doesn’t mean you can’t ever use macros in your Office documents again. We’ll show you how to disable the message without compromising the security of your Office programs. If you know what you’re doing, and you don’t want to see that message every time you open an Office document, you can disable it. RELATED: Macros Explained: Why Microsoft Office Files Can Be Dangerous
0 kommentar(er)
