VBA & Macro Problems

How to Share Global Excel Macros Using XLAM Add-ins

Chanuka GeekiyanageChanuka Geekiyanage Nov 2, 2026 872 views

Question details

The user wants to distribute and share Excel VBA macros across multiple users automatically, mimicking Word's Normal or global template behavior without using individual Personal.xlsb files.

How to Share Global Excel Macros Using XLAM Add-ins
Product
Excel
Device & OS
not provided
Scenario
Deploying custom VBA macros globally for a team or multiple users so that everyone has seamless access to the shared tools.
Observed behavior
Excel does not feature a direct equivalent to Word's Normal.dotm global template for sharing macros, requiring an alternative distribution method.
Before you start

Ensure that the folder or network drive where you intend to save the shared add-in has the appropriate read permissions for all target users.

Solution 1Recommended

Create and Deploy an Excel Add-in (.xlam)

The best way to share macros globally in Excel is to save your macro workbook as an Add-in (.xlam) and distribute it to users via a trusted location.

By saving your macros as an .xlam file, you create a dedicated add-in that operates quietly in the background. Unlike the PERSONAL.XLSB file, which is meant for a single user's local macros, an .xlam file can be stored in a shared network location or pushed to multiple users' startup folders.

1
Save the Macro Workbook as an Add-in

Open the workbook containing your VBA macros. Go to 'File' > 'Save As'. Choose 'Excel Add-in (*.xlam)' from the file type dropdown menu, select a shared network location or the Excel XLSTART folder, and click 'Save'.

2
Unblock the XLAM File

If the file is downloaded or moved via email, Windows might block it. Right-click the saved .xlam file in File Explorer, select 'Properties', check the 'Unblock' box at the bottom of the General tab, and click 'OK'.

3
Configure Trusted Locations

To prevent Excel from blocking the macros, open Excel on the user's computer, go to 'File' > 'Options' > 'Trust Center' > 'Trust Center Settings' > 'Trusted Locations'. Add the folder containing the .xlam file to this list.

4
Enable the Add-in in Excel

Go to 'File' > 'Options' > 'Add-ins'. At the bottom next to 'Manage: Excel Add-ins', click 'Go'. Click 'Browse', locate your saved .xlam file, ensure it is checked in the Add-ins list, and click 'OK'.

Create and Deploy an Excel Add-in (.xlam)
Administrator Deployment: For large teams, IT administrators can use Group Policy to automatically push the .xlam file to users' startup folders and configure the necessary trusted locations.
Manage Macros Easily with WPS Office

Create and Share Macros in WPS Spreadsheet

WPS Office provides robust support for creating, testing, and distributing VBA macros. You can seamlessly convert your macro-enabled workbooks into add-ins to share tools globally with your team.

  1. 1. Access the Developer Tools: Open WPS Spreadsheet and navigate to the 'Developer' tab to access the Visual Basic editor and write your macros.
  2. 2. Save as WPS Add-in: Click 'Menu' > 'Save As', and select 'WPS Spreadsheet Add-in (*.xlam)' from the file format dropdown. Save it to a shared team folder.
  3. 3. Load the Add-in: On the target computer, go to the 'Developer' tab and click 'Add-Ins'. Browse for the shared .xlam file and enable it so the macros load automatically.
Fully compatible with Microsoft Excel's .xlsm and .xlam macro file formats.Comprehensive Developer tools integrated directly into the top ribbon.Lightweight architecture ensures fast loading of multiple add-ins and scripts.Cost-effective solution for teams needing advanced spreadsheet automation.
microsoft office alternative - wps office

Frequently Asked Questions

What is the difference between PERSONAL.XLSB and an .xlam file?

PERSONAL.XLSB is a hidden, personal workbook stored locally on a single user's computer meant for macros that only they use. An .xlam file is a specialized add-in format specifically designed to be easily distributed and shared across multiple users or computers without conflicting with their personal macros.

Why are my shared macros not running after I enabled the .xlam add-in?

This is typically caused by Windows security blocking files originating from another computer or the internet. Close Excel, locate the .xlam file in File Explorer, right-click it, select 'Properties', and check 'Unblock'. Also, ensure the file is stored in a Trusted Location within Excel's Trust Center.

Can I automatically deploy an .xlam add-in to my entire company?

Yes. Network administrators can distribute the .xlam file to the local XLSTART folder on each user's computer via login scripts or Group Policy Objects (GPO). Any file placed in the XLSTART folder opens automatically when Excel launches.