Create Add-In

  • Thread starter Thread starter RK
  • Start date Start date
R

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.
 
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.
 
Back
Top