I am going to show you how to enable Ms excel macros . You will realize that there is some excel files, while opening, will require you to enable the Ms excel macros. Most of these files require the user to fill in like table. Also, these files are initially programmed with Excel VBA language. Here are simple step by step on how enable such file to be readable.
Enable Macros in Excel
Excel macro security protects your computer from viruses that may attack your computer through Excel Macros.
Here are step by step showing how change such a file.
-
- Open or unzip the excel file you are having
- trying to open the file will request you to enable the macros
In (1) shown above, is a zipped excel file. Unzip the file to be as (2) above.macros setting
Trying to open the file the above message displays.
- Click on Enable editing button.
Also read this
The file will be editable but the detail will be shown. Still macros is not enabled.
Below are procedures for Excel versions:
Help on Enable Macro: | |||
FOR EXCEL 2010 :- | |||
1 | Click the File Menu (Office BackStage), and then select Options from the left sidebar. | ||
2 | Click Trust Center, click Trust Center Settings, and then click Macro Settings. | ||
3 | Select “Enable all macros”. Click on ‘OK’. | ||
4 | Open the file again. | ||
FOR EXCEL 2007 :- | |||
1 |
|
||
2 | Click Trust Center, click Trust Center Settings, and then click Macro Settings. | ||
3 | Select “Enable all macros”. Click on ‘OK’. | ||
4 | Open the file again. | ||
FOR OTHER EXCEL VERSIONS :- | |||
1 | Select the Tools menu option and then select Macro and Security. In the resulting Security dialog, set the security level to Low by clicking the Low radio button. | ||
2 | Close the file and any other instances of the application currently running on the computer (close all excel applications that also use the application you are currently running). | ||
3 | Open the file again. | ||
4 | Click the Enable button to allow the macro to run. |
After enabling the macros the following image below shows how it should look like

Hope you will enjoy the post and it will help you. Thank you..