vba question

M

Matt Houston

hey,
i have made a few custom functions using vba, is there a way i can save
the code in a place where it can be accesses by any workbook i may be
using. at the moment I can only save it to the workbook im in at the
time and therefore only use it in that particular workbook.
thanks
 
N

Norman Harker

Hi Matt!

Save it in your Personal.xls file or create an Addin.

I'd go for the Addin approach as you can use an Addin to enrol your
functions in the function list categories each time Excel is opened.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
J

Jerry W. Lewis

Save the functions in an Add-In and select that Add-In from Tools|Add-Ins.

Jerry
 
Top