Custom Functions
 

Is there a way to store custom functions in 1 spreadsheet and have them
available in any new or old spreadsheets? Basically auto-load a library of
UDF's.

Hi
you could create an addin (*.xla file) and put your functions in this

--
Regards
Frank Kabel
Frankfurt, Germany

scott wrote:
Is there a way to store custom functions in 1 spreadsheet and have
them available in any new or old spreadsheets? Basically auto-load a
library of UDF's.

scott

Either stick the UDF's in a Personal.xls which can be opened hidden when Excel
starts or go the add-in route per your other post. See answer in
excel.programming NG.

Gord Dibben Excel MVP

On Mon, 27 Dec 2004 17:38:39 -0600, "scott" wrote:

Is there a way to store custom functions in 1 spreadsheet and have them
available in any new or old spreadsheets? Basically auto-load a library of
UDF's.