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.
Leave any Questions and Comments below and I will get back to you. I regularly publish on YouTube, Steemit, and christitus.com so if you’d like to see more videos and articles click the subscribe button in the top right.