What to do if macros are enabled but still disabled

Solution: 1. Click the "Options" button and check "Enable this content". 2. Click the "Office" - "Excel Options" button, check "Show the 'Developer' tab in the ribbon" in the new window, open "Developer Tools" - "Macro Security" at the top of the page, and check "Enable All Macros" and click "OK".

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2007 version, Dell G3 computer.

Method 1:

Normally, when running an excel file containing red, the program will give a notification to disable macros

Click the "Options" button, in the pop-up window, check "Enable this content", and click the "OK" button to run the corresponding macro.

Method 2:

Click the "Office Button" and click the "Excel Options" button from its extension panel.

In the window that opens, check the "Show the 'Developer' tab in the ribbon" item and click the "OK" button.

Then switch to the "Development Tools" tab and click the "Macro Security" button.

From the window that opens, check the "Enable all macros" item and click "OK".

Related learning recommendations: excel tutorial

The above is the detailed content of What to do if macros are enabled but still disabled. For more information, please follow other related articles on the PHP Chinese website!