View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_2_] Patrick Molloy[_2_] is offline
external usenet poster
 
Posts: 1,298
Default User Defined Functions

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" wrote:

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?