Click the Microsoft Office Button Button, and then click Excel Options.
Mar 05 2014 05:33 PM
Click Trust Center, click Trust Center Settings, and then click Macro Settings.
Click the option -
1. Enable all macros (not recommended, potentially dangerous code can run) :
Click this option to allow all macros to run. This setting makes your computer vulnerable to potentially malicious code and is not recommended.
2. Disable all macros except digitally signed macros :
This setting is the same as the Disable all macros with notification option, except that if the macro is digitally signed by a trusted publisher, the macro can run if you have already trusted the publisher. If you have not trusted the publisher, you are notified. That way, you can choose to enable those signed macros or trust the publisher. All unsigned macros are disabled without notification.