User Defined Functions

[scott]

I have a user that has about 10 custom functions. I'd like to create a
add-in to hold them and allow them to be used on any new or old spreadsheet
he uses.

Is an add-in the best way?

 

[Gord Dibben]

scott

An add-in is a good way to go.

Copy/paste the UDF's to a general module in a new workbook.

Then File>Saveas>Saveas File Type...scroll down to bottom of list and select
Microsoft Excel Add-in(*.xla)

Gord Dibben Excel MVP

 

[scott]

where do i place an add-in so it's always loaded? i didn't think that was
possible without manually adding the add-in.

 

[Shetty]

You need to load this addin only once. Then next time it will load
automatically. It is also possible to load the add in programatically.
Regards,
Shetty.

 

[Guest]

Save the xla in the XLStart folder & it will be loaded automatically - very
similar tio the personal.xls workbook that many people like to use.
If you have an alternative start up folder - see under Tools/Optios - then
you could put the XLA there instead.
Both these can be used, or indeed, simply use the Add-In Manager -
Tools/Add-Ins

 

[scott]

thanks, that is exactly what i need.

Save the xla in the XLStart folder & it will be loaded automatically -
very
similar tio the personal.xls workbook that many people like to use.
If you have an alternative start up folder - see under Tools/Optios -
then
you could put the XLA there instead.
Both these can be used, or indeed, simply use the Add-In Manager -
Tools/Add-Ins

 

[scott]

How can I load an add-in via code? I thought that was not possible.

 

[Tushar Mehta]

Check the Installed property of the Addin object.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions