View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default User Defined Functions

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?