Hi,

I have a workbook which (via code) copies one of the worksheets into a new
workbook. The copied worksheet contains cell formulas using a function in
the original workbook. When copied, the new worksheet returns a #NAME?#
error in the cells using the function.

Can I make the function available to all open workbooks? Or can I employ
code to copy the module containing the function into the new workbook?

Thanks in advance,

Damien