To control when your macros run, you could assign them to unique events within Excel, which include opening a workbook, changing a sheet, or clicking a button. This is certainly done through the VBA editor, in which you can create party-handler procedures that bring about your macros. I found a https://www.customguide.com/word/how-to-create-a-macro-in-word