CODEWITHSUNDEEP
vbaexcelexcel-2013
vladiz
vladiz

Reputation: 174

How to make excel addin for distributing excel macro

I have two Excel macros in my personal workbook which I use with a combination of keys.

Now other users want to have these macros and use them with a combination of keys. I have found information that the easiest way is to create an Excel addin and they have to install it.

What is the process of creating this excel addin with my two macros, and then how can I install it to other users?

We are using Excel 2013.

Upvotes: 1

Views: 518

Answers (1)

INOPIAE
INOPIAE

Reputation: 293

Create a new file

Copy your macros to the new file

Save the new file as Excel-Addin (*.xlam)

Distribute the Excel-Addin

On the other PC Go to Excel -Options - Addins

Add the botton choose Excel-add-ins press goto

Search for the addin file and tick it

Upvotes: 2

Related Questions