Excel Macro Enabled Template. From the insert window select ms excel 40 macro then click ok. You can hit altf11 or on the ribbon click developer visual basic 3.
In the “excel options” dialog box, click “trust center settings” in the “trust center” option. The document will save as '*.xlsm', which means that you can now enable macros and write instructions that excel will follow. In the file tab, click “options.”.