How can I make my custom VBA fuctions available to users who are entering
formulas in cells?

Thanks,

Keith

Place the functions in a module and declare the functions Public. You can
then use these functions the same as you would any other Excel formula
function.
--
HTH...

Jim Thomlinson


"keithb" wrote:

How can I make my custom VBA fuctions available to users who are entering
formulas in cells?

Thanks,

Keith

Put it in a general module in a workbook, then make that workbook an addin
and have your users install it under Tools=Addins.

http://support.microsoft.com/?id=167909
XL: Securing Visual Basic Code in Microsoft Excel

http://support.microsoft.com/?id=156942
XL97: How to Create an Add-in File in Microsoft Excel 97

http://msdn.microsoft.com/library/en...xceladdins.asp

http://msdn.microsoft.com/library/en...exceladdin.asp

http://www.j-walk.com/ss/excel/tips/tip45.htm
Excel 97: Creating Add-Ins
--
Regards,
Tom Ogilvy


"keithb" wrote in message
...
How can I make my custom VBA fuctions available to users who are entering
formulas in cells?

Thanks,

Keith