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.

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

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"RK" wrote in message
...
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.

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" wrote in message
...
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.

Got it! Thanks for your help, guys!