How to set security to enable macros in Microsoft Excel?

By default any Macro or VBA code inside or Excel file will be disable for security reason. Therefore we must understand the risk but for me as long we know the source then should be OK.

Follow this step to change or set the security to enable macros:

METHOD 1:

1. Open any Excel file and click at File top left.
   
   
   
   
   
   
   
   
   
   
   
   
   
2. Click at Options below left.
   
   
   
   
   
   
   
   
   
   
   
   
   
   
3. Click at Trust Center under Excel Option.
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
4. Click at Trust Center Setting under Excel Option.
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
5. Click at Macro Settings under Trust Center.
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   Choose either one but since we know the source code prefer to choose no 4 which is
   "Enable all macros (not recommended; potentially dangerous code can run)" to ease our VBA code writing later on.
   
   
6.  Click OK.
   

          OR

METHOD 2:

1. Click at Developer tab on top follow by Macro Security.
   
   
   
   
   
   
   
   
   
   
   
   
   
2. Repeat Step 5 and 6 in Method 1.
   

Macro security setting is completed.

Microsoft Reference