Excel cannot run macros and the solution is for you

While working with Excel, many of you often encounter the error that Excel cannot run macros and don't know what to do. TipsMake has detailed suggestions to fix this situation in the article, see now to fix the error!

Many users need to enable macros in Excel. However, it is not always possible to turn it on. Many of you have encountered the problem of not being able to run macros in Excel 2013/2016/2019. or other versions. So, today, TipsMake will help you fix the error of Excel not being able to run macros .

Excel cannot run macros and the solution is for you Picture 1

Instructions on how to quickly fix Excel not being able to run macros

The error of not being able to run macros in Excel 365, 2019, 2016. has many causes. It may be because the user has not enabled macros properly, because by default macros will be disabled. Or maybe it's because Microsoft has blocked macros, etc. Whatever the cause, below are the solutions for you to fix.

Share how to enable macros for Excel

There are quite a few different ways to enable macros in Excel. However, turning on macros also has its own advantages and disadvantages. Therefore, to ensure safety, you should only enable safe macros, macros you wrote or recorded yourself, macros from a trusted source, or if using VBA code, make sure you have reviewed and reviewed this code. fully understand.

Instructions on how to enable macros for a certain file

Enable macros via the security warning bar

In case the user opens the worksheet containing the macro for the first time. A yellow notification bar will appear on the worksheet as shown.

Excel cannot run macros and the solution is for you Picture 3

Or if the Visual Basic Editor is open at the time the user opens the file that contains the macro. The notification will display as follows.

Excel cannot run macros and the solution is for you Picture 5

Therefore, you need to click Enable Content or Enable Macros to open it. If you do not want to enable macros, the user clicks on the X to close the file. This warning will disappear but the macro will still be turned off and when running the macro a warning will appear (illustration below).

Excel cannot run macros and the solution is for you Picture 7

Activate macro with Backstage view : Users just need to click the File tab > Select Info > Find the Security Warning area , click the arrow in the Enable Content line > Select Enable All Content .

Excel cannot run macros and the solution is for you Picture 9

Note: If you want to find the Shortcut key to open macros in Excel, users can press the key combination Alt + F8 to open the macro dialog box. Or you can learn how to create macro shortcuts in Excel to set it up according to your personal needs.

Enable macros in all working windows (fix error of not being able to run macros in Excel 2016)

Here's how to enable macros in every Excel workbook by default. If you encounter an error of not being able to run macros, you can apply (I did it on Excel 2016, other versions such as Error of not being able to run macros in Excel 2010, 2019 apply similarly). Note, enabling all macros in all working windows can make your computer vulnerable to potential code attacks, so you should consider before proceeding.

1. Step 1 : Click on Excel's File tab > Select Options in the list on the left.
2. Step 2 : Click on Trust Center > Then tick the Trust Center Settings button.
3. Step 3 : Continue to click on Macro Settings in the list on the left > Then tick Enable all macros. and T rust center to the VBA project object model as shown and then click OK .

Excel cannot run macros and the solution is for you Picture 10

How to enable macros for one time only

Sometimes users may receive an Excel file with VBA code, but you don't want to make it a trusted document. Therefore, the way to enable macros in one go will be applicable to this case.

1. Step 1 : Open that Excel file > Click File > Info .
2. Step 2 : In the Security Warning area , click Enable Content > Select Advanced Options .
3. Step 3 : When the dialog box displays, check the Enable content for this session line and click OK .

Excel cannot run macros and the solution is for you Picture 12

Fix bug where Microsoft blocked macros

The reason why macros in Excel do not run may be because Microsoft has blocked macros. At this time, when opening the Excel file, a pink warning will appear 'Microsoft has blocked macros from running because the source of this file is untrusted'. To fix the macro have been disabled error in Excel, unblock it with the following steps:

1. Step 1 : First, close the Excel workbook that contains this blocked macro.
2. Step 2 : Open File Explorer, find the location to save the file > Right-click on the Excel file > Select Properties .
3. Step 3 : Tick Unblock and click OK to save.

Excel cannot run macros and the solution is for you Picture 14

Instructions on how to install VBA (visual basic for applications)

Macros in Excel not running are also likely because Excel has not installed VBA. Therefore, to fix the macro have been disabled error in Excel, you need to install VBA for Excel.

1. Step 1 : First, click the Start button > Type and open Control Panel .
2. Step 2 : Click on Programs > Continue right-clicking on the Microsoft Office you are installing > Select Change .
3. Step 3 : Tick the Add or RemoveFeatures line and click Continue > Find the Office Shared Features section and click the + sign to expand > Scroll down to see Visual Basic for Applications > If there is a red X, it is not installed > Click on this tool and then select Run from My Computer .

Excel cannot run macros and the solution is for you Picture 16

1. Step 4 : When the installation is complete, the red X will disappear > Click Next > Wait for this process to complete, then click Close to close the window.

Above are all the solutions when Excel cannot run macros. Hope you guys do it successfully!

Marvin Fry

Update 09 December 2023