To save some time getting a New Excel Macro-Enabled Workbook ready and well configured, you can utilise the template test.xlsm I have already developed by following the steps below:

  1. Download the template test.xlsm. Do not open the file directly after download!
  2. Right-click the file > Properties > General and check Unblock > Apply > OK (see Figure 16).
  3. Figure 16: File properties unblock
    Figure 16
  4. Delete the test.xlsm file on your computer.
  5. Re-download the file again and then open it in Excel.
  6. Give permission and Enable macros: Developer tab > Macro Security > Enable VBA macros. (see Figure 17).
Figure 17: Macro security settings placeholder
Figure 17