Once decided on the extent of permission, follow the listed steps to enable excel macros:

How to enable macros excel 2007. On the trust center choose macro. Select trust center in the window that pops up. Disable all macros with notification:

Click the trust center settings button on the bottom right of the trust center tab. In the trust center, click macro settings. Click trust center, and then click trust center settings.

Go into excel options, click the trust center entry on the left, then click the trust center settings button on the right. With an excel file opened click on the ‘office’ button. Excel will inform you this is not recommended and potentially.

Office button > excel options > trust center > trust center settings > macro settings > disable all macros with notification. On the right pane, click the “trust center settings” button. Then when you open the workbook you should get a message bar.

In excel, click the office button in the upper left corner of the screen. 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. On the “excel options” window, in the left sidebar, click “trust center.”.

Make the selections that you want, then click ok. The office button is the fancy button in the top left corner — the one with the colorful. If you select this button, the macro will be disabled, but a security alert will appear if there are macros in the file.