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.

Chris Titus Tech


Exclusive Content

  • Members Section (CC Only)
    • Digital Downloads with Guides and Pre-Built Images
    • Monthly Members Only Video
    • $5 Per Month (100% of Proceeds goes to Chris Titus Tech)
  • YouTube Chris Titus Tech Membership (All Payments Accepted)
    • Monthly Members Only Video
    • YouTube Emojis for Comments and Live Chat
    • YouTube Badges that changes based on membership time for comments and chat.
    • All YouTube comments are highlighted when I review comments daily.
    • $4.99 Per Month (70% of the Proceeds goes to Chris Titus Tech)

Chris Titus
Chris Titus
Tech Content Creator