Create Add-In

[RK]

I have written some excel functions for my project. How do I make them into
an add-in so they're available for all my spreadsheets and other users?

Thanks.

 

[Norman Harker]

Hi RK

Open a new workbook
Activate the VBE
Insert a Module into the new workbook
Copy and paste your UDFs to this new Module
Back into Excel
File > Save As
In Save as Type dialog select "Microsoft Excel Addin (*.xla)"
OK

You can place this Addin in the Library file and it will then be
available (next time Excel opens) in the Tools > Addins dialog.

A typical Library file location is:

C:\Program Files\Microsoft Office\Office\Library

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Andy Wiggins]

This file might be a help:

It contains a workbook that shows how to create an interactive add-in
controlled by a toolbar.
The toolbar is created when the add-in is loaded, and deleted when the
add-in is closed.

http://www.bygsoftware.com/examples/excel_addin.htm
The code is open and commented.
--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"

 

[RK]

Got it! Thanks for your help, guys!