User Functions/Personal.xls

  • Thread starter Thread starter LarryP
  • Start date Start date
L

LarryP

If I write a user function and want it to be available in
all my Excel files, will putting it in Personal.xls do the
job? For example, Excel doesn't appear to have the
MSAccess Between() function. Can I write my own, put it
in my Personal.xls, and be able to use it everywhere? If
I do, what happens when I send somebody a copy of the
file? (I'm afraid I know the answer to that, but if
somebody knows a way to make it portable I'm certainly
ready to listen!).
 
Hi
though I would recommend you use the solution John provided to you you
may want to take a look at the following link:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Problem with a UDF in your personal.xls:
- user has to enable macros to make your calculations work
- if you email the file the recipient does not have this macro

And in your case the overhead is not worth the effort :-)
 
Back
Top