How to make a macro available in all workbooks

One of the best features of Ms Excel is Macros. In our earlier blog we have shown how to write excel macro to compute liner interpolation, and now we will see how to make a macro available in all workbook.

Excel Macro is only available in the workbook on which we created it. However, with the following method you can make it available for all the workbooks/excel files.

Steps to make Macro available in all Workbooks

1. Open Visual Basic Editor by navigating Developer Tab > Visual Basic
2. Create Module by going to Insert Tab > Module
3. Write the desired function/macro that you need to make it available for all excel workbook/files
4. Save the current workbook with “.xlam” extension (say “LinearInterpolation Function.xlam”) in the default directory which windows prompts while saving.
5. Go to Files > Options > Add-in and select the above Excel file/Macro from the list of Inactive Application Add-ins & Click Go. This step makes the function/macro available for all workbook.

Related Posts

• Automated interpolation formula for Excel: Define excel interpolate function & use it forever
• Evaluates String as if it Were a Formula in Excel
• How to check if excel cell is empty or blank
• How to convert columns into CSV using 1 simple Ms Excel function
• How to remember difference between Unique and Distinct?
• Microsoft is giving Ms Office 365 Free: Two ways to get all office application for free
• Resize all images in Ms Word to same size with few click
• Simple trick to remove unwanted line break in Ms Word while copy/paste in 1 click

C P Gupta

C P Gupta is a YouTuber and Blogger. He is expert in Microsoft Word, Excel and PowerPoint. His YouTube channel @pickupbrain is very popular and has crossed 9.9 Million Views.