User Defined Functions

[Guest]

Can someone direct me to a procedure on how to set up a user defined function
that will work with EVERY excel workbook, not just the workbook that the
function resides in?

Thanks,
Barb Reinhardt

 

[Niek Otten]

Hi Barb,

Here's a professional article about distributing macros (and functions) by MVP Jan Karel Pieterse:

http://www.jkp-ads.com/Articles/DistributeMacro00.htm

--
Kind regards,

Niek Otten


| Can someone direct me to a procedure on how to set up a user defined function
| that will work with EVERY excel workbook, not just the workbook that the
| function resides in?
|
| Thanks,
| Barb Reinhardt

 

[papou]

Hello Barb
Place your UDF into a peronnal.xls macro workbook, you will thus have this
function available when you open Excel.

HTH
Cordially
Pascal

 

[Guest]

Thank you. That's exactly what I was looking for.