Reopen the file and you should see the 'enable macros' button.

How to enable macros in excel. In the trust center settings. To get macros enabled in all excel workbooks by default, this is what you need to do: I took a copy of it and opened it from a windows 2016 server i have but i cant enable content to.

Excel also has a checkbox for enable excel 4.0 macros when vba macros are enabled. If you select this checkbox all of the above settings for vba macros will also apply to excel 4.0. And then click ‘trust center settings’.

Create a shortcut key combination if you like. Macros are disabled by default, but you can easily enable them. Don't click enable content (see first screenshot on this page) if you don't trust the owner of the excel file.

Use this security level if you are downloading a lot of excel files from the internet. Right click on the filename in explorer, select properties. You determine these default settings through the trust center, which is where you can see and set.

If you do not see the above message, you can follow the below steps to enable macros in excel. This will help you identify the macro later. Enabling macros in excel 2010 and 2013:

Open a microsoft excel file, and navigate to ‘file’ > ‘options’ > ‘trust center’. 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. Click the file tab, and then click options at the very bottom of the left bar.