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