Deploy excel macros to all xls files on startup

Deploy excel macros

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

  1. Create and test your macro
  2. Save as – Personal.xls (Macro-Enabled workbook)
  3. Copy the personal file to your C:Program Files\Microsoft Office\Office1#\XLStart folder
  4. 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.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: