To use a function from a different workbook, you need to
put the name of the workbook in front of the function
name. For example, if the function in Personal.xls is
called Fred, then to use it on a worksheet, use
=Personal.xls!Fred(X,Y)
HLH
Helen
-----Original Message-----
Need help on the use of custom functions - I have built
some custom
functions for various tasks, but can't get other
workbooks to "see"
them when I put them in my Personal.xls file. This is
not true of the
macros I have in Personal.xls - they work fine in any
sheet.
Am I missing some toggle switch or something that will
enable these
custom functions to work from the Personal.xls file? It
would seem to
me that these especially would need to be accessible from
the
Personal.xls.
Thanks for any help,
jwa76
---
Message posted from http://www.ExcelForum.com/
.