How to Share Global Excel Macros Using XLAM Add-ins
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.

- 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.
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.
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.
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'.
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'.
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.
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 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. Access the Developer Tools: Open WPS Spreadsheet and navigate to the 'Developer' tab to access the Visual Basic editor and write your macros.
- 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. 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.

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.




