This page looks best with JavaScript enabled

Deploy excel macros to all xls files on startup

 ·  ☕ 1 min read  ·  ✍️ Chris Titus

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.

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.

Share on
Support the author with

Chris Titus
WRITTEN BY
Chris Titus
TechGuy On YouTube