Excel - MacOS Path to Personal Macros Library

~/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/User/PERSONAL.xlsm

To prevent it from opening every time you launch excel, open excel, focus on your personal macros workbook, then go to "Window > Hide".