Run a macro - Excel - Office Support

In addition, you can run a macro automatically when you open a workbook. ... Workbooks in the XLStart folder are opened automatically whenever Excel starts.

support.office.com