View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Scott Scott is offline
external usenet poster
 
Posts: 149
Default User Defined Functions

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.


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
scott

An add-in is a good way to go.

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

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

Gord Dibben Excel MVP

On Mon, 27 Dec 2004 16:25:40 -0600, "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?