To enable macros in excel, please refer to the following steps:

Enable macros excel 2007. Click enable content > advanced options in the security warning area. Click trust center settings in the window on the right. In excel, click the office button in the upper left corner of the screen.

Now, choose macro settings and select the enable all. In order to enable excel macros, open the microsoft excel. Click trust center in the menu on the left.

Enabling macros in excel 2007. Another way to enable macros for a specific workbook is via the office backstage view. To do that, click options (excel 2010 to 2016 versions) or microsoft office button (excel 2007), and then click trust center > trust center settings > macro settings.

In the file tab, click “options.”. Then go to trust center, trust center settings, and macro. Next select the ‘trust center’ > ‘ t rust center settings’.

Next, look at the left hand listing. By default the developer tab is not shown in the office ribbon. Potentially dangerous code can run)” option.

Then click on ‘excel options’ (present at the bottom). This setting makes your computer vulnerable to malicious code. Once done, go back to the excel options dialog and choose trust center from the left pane.