In the macro settings category, under macro settings, click the option.

How to enable macros in excel 2007. Click the trust center settings button on the bottom right of the trust center tab. Then click on ‘excel options’ (present at the bottom). On the “excel options” window, in the left sidebar, click “trust center.”.

In the popular category, under top options for working with excel, select the show developer tab in the ribbon check box, and. The office button is the fancy button in the top left corner — the one with the colorful. Select trust center in the window that pops up.

You’ll see a “trust center” window. Click trust center settings in the window on the right. To enable the developer tab, see show the developer tab.

To enable macros in excel, please refer to the following steps: On the developer tab, in the code group, click macro security. Select one of the following.

With an excel file opened click on the ‘office’ button. It allows you to enable macros in excel. Make the selections that you want, then click ok.

Next select the ‘trust center’ > ‘ t rust center settings’. In the trust center, click macro settings. Click the microsoft office button, and then click excel options.