How to enable macros in Excel?MiniToolprovides a specific guide for you in the following content.
If you are looking for free data recovery software,MiniTool Power Data Recoveryis highly recommended.
It is able to recover documents, photos, videos, and so on.
you could use the free edition to scan and recover up to 1GB of files.
Why not have a try?
They are pretty convenient when used in Excel.
It can preserve your time and energy to a great extent.
But it is not safe to enable all the macros in all files.
Macros are easily becoming viruses or malware attacks which may make your box or internet infected.
Therefore, macros parameters are disabled by default in Microsoft Office like Excel and Word.
When you gotta enable macros in Excel, you gotta confirm the security of the file source.
What is a macro virus?
If you want to learn about it, this post provides detailed information about it.
Besides, you’ve got the option to know how to prevent it.
You may also receive a simple message thatMacros have been disabledbefore you upgrade the macros.
In this section, two useful methods are provided to help you solve the Excel macros not working problem.
Method 1: Make the Document Trusted
Step 1: SelectEnable Contenton the SECURITY WARNING message.
Step 2: SelectYesin the popup window to make the document trusted.
Then, macros are enabled on this document.
If you download files from a trusted location, there will be no warning message.
Step 1: SelectFile>Options.
Step 2: ChooseTrust Center>Trust Center tweaks.
Step 3: In the following window, selectMacro prefs.
Step 4: Select one option based on your needs, then clickOKto save the change.
MiniTool Power Data Recovery is a professional and reliablefree data recovery software.
There are three choices to disable macros.
If you want to enable macros in this file, yo take these actions.
Step 1: Click onFile>Info.
Step 2: If the file contains macros, you’re able to find theSecurity Informationsection.
Step 3: Click onSecurity Informationand then chooseEnable All Content.
The macros will be enabled when you are using this file.
