| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I would like to delete a custom toolbar from the workspace. How? | Setting up and Configuration of Excel | |||
| Excel 2002 custom toolbars | Excel Discussion (Misc queries) | |||
| Deleting custom Commands from File Menu are nor saved next time w. | Excel Worksheet Functions | |||
| How to load Engineering Functions into the Fx function wizard? | Excel Worksheet Functions | |||
| Where can I see VBA code for financial functions? | Excel Worksheet Functions | |||
Linear Mode
