On the trust center choose macro.
How to enable macros in excel 2007. Click trust center, and then click trust center settings. Click the trust center settings button on the bottom right of the trust center tab. In excel 2010, the security messages are the same, but the coloring makes the warning more obvious.if the workbook contains just macros, the security warning will read macros have been.
Then click on ‘excel options’ (present at the bottom). Next select the ‘trust center’ > ‘ t rust center settings’. To enable the developer tab, see show the developer tab.
Enable macros in excel 2007: Select one of the following. To enable macros in excel, please refer to the following steps:
By default, macros remain disabled in ms excel. Click the microsoft office button, and then click excel options. Next, look at the left hand listing.
In the backstage view under help, click. In the macro settings category, under macro settings, click the option. Disable all macros with notification:
Click “ ok ” twice to save the changes. Click trust center settings in the window on the right. In the trust center, click macro settings.