Deploy excel macros to all xls files on startup

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
Done!

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.