By Default, All Macros option is disabled in Excel 2010 due to the fact that any kind of malicious code can run which can seriously harm your work. However, if you’re an advanced user and want to enable all the macros, you can do it from Excel 2010 Trust Center Settings.
To enable all macros, on File menu, click Options.
It will bring up Excel Options, from left sidebar, click Trust Center and from main window, click Trust Center Settings.
This will lead you to Trust Center dialog, from left sidebar, select macro Settings and from main window, click checkbox of Enable all macros option and hit OK to enable all the macros.