To deploy excel macros on every excel file you open, you will need to create a personal file in your XLStart folder.
Here is a step-by-step
- Create and test your macro
- Save as – Personal.xls (Macro-Enabled workbook)
- Copy the personal file to your C:Program Files\Microsoft Office\Office1#\XLStart folder
I have no clue why the articles on TechNet and Microsoft’s Knowledge-base are so long when this is all you have to do. Other than its Microsoft 😉
Note: I’ve also heard of folks dropping there *.bas macro files directly into XLStart and having the same result, but I personally have not used that method.
I live stream on Twitch and encourage you to drop in and ask a question. I regularly publish on YouTube and christitus.com, but if you need immediate assistance, check out our discord channel at Chris Titus Tech Discord.