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

You can place the function code into a workbook which you save as an Add-in

Or place the code into your Personal.xls

I prefer the add-in just because I don't have to type the name as in

=Personal.xls!function(cellref,args)

With the add-in just enter as =function(cellref,args)


Gord Dibben MS Excel MVP

On Thu, 17 Jul 2008 09:38:54 +1000, "Damien McBain" wrote:

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