| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
User define function
You can place it in your Personal Macro Workbook, more commonly known as
Personal.xls When stored in the XLSTART folder, Personal.xls will open whenever you start Excel. You can save it "hidden" so it stays in the background with your macros and functions available for all open workbooks. When using Personal.xls and assigning macros to buttons you have to precede the macroname with the filename. i.e. Personal.xls!mymacro Same thing for User Defined Functions =Persoanl.xls!funcname(args) If you store all macros and UDF's in an Add-in(*.xla) you don't need the filename. =funcname(args) is sufficient. Gord Dibben MS Excel MVP On Sat, 10 Feb 2007 15:11:00 -0800, Lee wrote: how to make my vba function available in new worksheet |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| User Defined Function | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
| how to move user defined function | Excel Worksheet Functions | |||
Threaded Mode
