How to set excel macro security/ to enable or disable macros in Excel

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.

 
Also read this

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 macrosmacros settingIn (1) shown above, is a zipped excel file. Unzip the file to be as (2) above.macros settingTrying 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
Click the Microsoft Office Button                 , and then click Excel Options.
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

macros setting
macros setting

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