vba question

  • Thread starter Thread starter Matt Houston
  • Start date Start date
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
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top