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

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


"Barb Reinhardt" wrote in message
...
| 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

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

"Barb Reinhardt" a écrit dans le
message de news: ...
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

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

"Niek Otten" wrote:

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


"Barb Reinhardt" wrote in message
...
| 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